View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mangler Mangler is offline
external usenet poster
 
Posts: 1
Default Large Number Question

If I have a cell formated as number it displays large numbers weird.
Say I enter this value into a number formatted cell :
11111111111111111111111111, after I press enter to commit the value
it changes to this : 11111111111111100000000000.

How can I get that cell to display the large number correctly?