Search:  

 
theme to white backgroundlet page decide theme
HomeFind ServiceReviewsISP NewsFAQsForumsToolsDatabaseAbout 
 
   All ForumsHot TopicsGallery






how-to block ads


 
Forums » Tech and Talk » OS and Software » Microsoft Help » Another excel question
Search Topic:
 Share Topic:
RSS topic:
toggle:
flat / full
normal / watch
Posting:
Post a:
Post a:
Links: ·MS Apps FAQ ·Windows XP FAQ ·Product Catalog ·Windows Home
[Outlook] What would be the best way to do this? »
« IE7 Tip for moving Classic Menu to top!  
AuthorAll Replies


philfna
Premium
join:2003-12-30
Wisconsin		reply to pog
Re: Another excel question

I was actually for the number not just the formatting...thanks for trying
to forum · permalink · · 2007-01-18 17:57:49 · Reply to this


AlphaOne
I see
Premium
join:2004-02-21		 Did my solution work?
to forum · permalink · · 2007-01-18 18:29:40 · Reply to this

efrem

join:2002-04-03
Westport, CT

reply to philfna
said by philfna See Profile :

I was actually for the number not just the formatting...thanks for trying :-)
If I understand your request (and that's a real if), how about this:

="1 / "&ROUND(1/A1,2)

So if you have 0.75 in Cell A1 and that formula in Cell B1, then Cell B1 will display 1 / 1.33 .

Does that give you both the number AND the format you want?
to forum · permalink · · 2007-01-18 18:57:22 · Reply to this
Forums » Tech and Talk » OS and Software » Microsoft Help[Outlook] What would be the best way to do this? »
« IE7 Tip for moving Classic Menu to top!  

Friday, 04-Dec 04:00:14 Terms of Use | Privacy Policy | Hosting by www.nac.net - DSL,Hosting & Co-lo | feedback | contact
over 10 years online! © 1999-2009 dslreports.com.
page compression OFF
Most commented news this week
· [162] Comcast Releasing Promised Usage Meter
· [140] Avast Antivirus Has Gone Mad
· [104] Graduate Student Unveils Sprint's GPS Sharing With Feds
· [102] Comcast Makes NBC Universal Acquisition Official
· [85] Google Invades ISP, OpenDNS Turf With Google Public DNS
· [81] Latest Consumer Reports Survey Not Kind To AT&T
· [70] Baltimore To Ban Lazy Cable Installs
· [65] Sprint Defuses GPS Privacy Media Bomb
· [64] Broadband Killed The Game Console
· [59] FCC Ponders Moving From PSTN To IP Voice
Most people now reading
· False positive in Avast! or is it real? [Security]
· Windows 7 boot manager editing questions [Microsoft Help]
· Connecting to Google Voice Via SIP [VOIP Tech Chat]
· [Rant] Disrespect of PTO [Rants, Raves, and Praise]
· [WotLK] Whats the level 80 pve spec for mages? [World of Warcraft]
· Connect Blu Ray Player to Internet - Ethernet Port? [Verizon FIOS TV]
· [ Classes] Warlock Thread [World of Warcraft]
· [Business] how to bridge a smc 8014 business class modem [Comcast HSI]
· [WIN7] Outlook express under Windows 7? [Microsoft Help]
· Opening a file download dialog from a JavaScript function. [Webmasters and Developers]