Thread: Number Format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Number Format

Your number is so large that Excel can only display it in scientific
notation. To see the entire number as entered enter an apostrophe as the
first character and follow that with your number. Excel will treat the entry
as a text entry and not as a numeric one.

--
Kevin Backmann


"BAKERSMAN" wrote:

I type 93049044627327087000052. I get 9.3049E+22 in the cell. Can you please
tell me how to format the cell so I can see the whole number in cell?