site Search:


Home Reviews Tools Forums FAQs Find Service ISP News Maps About  
 
    All Forums Hot Topics Gallery






how-to block ads

  
Forums >

OS and Software > Microsoft Help > Another excel question

Search Topic:
 Share Topic
Posting?
Post a:
Post a:
Links: ·MS Apps FAQ ·Windows XP FAQ ·Windows 7 FAQ ·Windows Home ·Office Home
AuthorAll Replies

efrem

join:2002-04-03
Westport, CT

reply to philfna

Re: Another excel question

said by philfna:

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 ·
Forums > OS and Software > Microsoft Help

Monday, 13-Feb 03:40:30 Terms of Use & Privacy | feedback | contact | Hosting by nac.net - DSL,Hosting & Co-lo
over 12.5 years online! © 1999-2012 dslreports.com.
Most commented news this week
Hot Topics