Search:  

 
theme to black 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

efrem

join:2002-04-03
Westport, CT

reply to philfna
Re: Another excel question

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!  

Thursday, 03-Dec 14:34:52 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
· [129] Avast Antivirus Has Gone Mad
· [103] Graduate Student Unveils Sprint's GPS Sharing With Feds
· [81] Latest Consumer Reports Survey Not Kind To AT&T
· [75] Comcast Makes NBC Universal Acquisition Official
· [70] Baltimore To Ban Lazy Cable Installs
· [64] Broadband Killed The Game Console
· [55] Rogers Unveils The ISP Dream Model
· [47] ACTA: Global Three Strikes
· [43] Cable Industry's 'Adoption Plus': Altruism Or PR Stunt?
Most people now reading
· False positive in Avast! or is it real? [Security]
· Warrior tank seem underpowered these days [World of Warcraft]
· [TWC] Audio/Video outage in Brooklyn [Time Warner Cable TV/Voice]
· [Rant] Disrespect of PTO [Rants, Raves, and Praise]
· Quality/longevity of 15A 120V receptacles [Home Repair & Improvement]
· Many Sites Unreachable [Rogers]
· Microsoft actively urges IE 6 users to upgrade [Security]
· Usenet Services- Clarification [TekSavvy]
· HELP! Leveling up! [World of Warcraft]