LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Number Format question

I have a simple formula in one cell, dividing A1 into B1 and I cannot find
the correct formatting to have it read correct e.g. 71.5 The closest I get
is either 71.5% or .715. I can obviously multiply the cells by a 100 but it
seems Excel should have the above fomatting option - am I wrong?

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Number Format Question snolte Excel Discussion (Misc queries) 1 May 13th 09 11:56 PM
format number-date question driller Excel Discussion (Misc queries) 16 April 14th 09 06:38 AM
Number format question BobK Excel Discussion (Misc queries) 2 October 24th 08 08:12 PM
Simple Question, display only part of a date in Number format DB Explorer Excel Worksheet Functions 6 March 17th 06 11:47 AM
Custom Number format question Joh Excel Discussion (Misc queries) 5 October 25th 05 02:31 PM


All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"