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


pog
Premium
join:2004-06-03
Kihei, HI
·Hawaiian Telcom

reply to philfna
Re: Another excel question

You could also enter custom formatting:

1\/#

From the menu, click format|cells and enter this into the "type" field. I use an old version of Excel here so your version's GUI layout may be different.

Note, the value of the cell is unchanged... it still equals your X
--
My Site
to forum · permalink · · 2007-01-18 17:42:41 · Reply to this


philfna
Premium
join:2003-12-30
Wisconsin		 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!  

Saturday, 28-Nov 09:18:20 Terms of Use | Privacy Policy | Hosting by www.nac.net - DSL,Hosting & Co-lo | feedback | contact
over 10 years online! © 1999-2009 dslreports.com.republican-creole
page compression OFF
Most commented news this week
· [121] Time Warner Cable Fires Broadside At Broadcasters
· [112] New AT&T Ad Campaign Hits Back At Verizon
· [96] Apple Joins AT&T Verizon Snark Fest
· [87] New Bill Takes Aim At Higher Verizon ETFs
· [71] TiVo Sees Record Customer Losses
· [69] In-Flight Internet Headed For Bumpy Landing?
· [68] Verizon CEO: Hulu Will Be Dead Soon
· [62] Thanksgiving Open Thread
· [52] Weekend Open Thread
· [40] EFF Wages War On Fine Print
Most people now reading
· Windows 7 boot manager editing questions [Microsoft Help]
· Why does it take so long? Mail question [General Questions]
· 3.x Feral Druid - Bear Tanking Guide [World of Warcraft]
· [Future9] Future9 status [VOIP Tech Chat]
· 'The antivirus industry sucks' [Security]
· [Newsgroups] Newzleech down? [Filesharing Software]
· tx AM FM SSB CW - stupid radio technical question - beware - [Wireless Service Providers]
· Is Gear Score now the new requirement to get pug invite? [World of Warcraft]
· IPComms Free DIDs now with sip registration maybe?? [VOIP Tech Chat]
· Nvidia Forceware for Windows XP\2000\03 195.62 [Software]