republican-creole
site Search:


 
    All Forums Hot Topics Gallery






how-to block ads


 
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


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


AlphaOne
I see
Premium
join:2004-02-21

Did my solution work?


efrem

join:2002-04-03
Westport, CT

reply to philfna

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?

Monday, 28-May 07:16:40 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