Thread: Decimal points data not displaying as expected
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
g. spence[_2_] g. spence[_2_] is offline
external usenet poster
  
Posts: 1
Default Decimal points data not displaying as expected
When entering the following number in Excel it doesn't display correctly
either in the cell or the formula bar -

Cell is formatted as Number with 9 decimal points.

I enter this number: 287488758463.904876
Cell displays: 287488758463.905000000
Formula Bar displays: 287488758463.905

How can I get it to display exactly what is typed into the cell?
Reply With QuoteReply With Quote