Thread: Stange numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pgarcia pgarcia is offline
external usenet poster
 
Posts: 304
Default Stange numbers

Hello all,
Some one in my office has ask me for help and I could not figure this out.
The setup:you have a set of rows with number and those number are formatted
with "Accounting" two decimals no symbol. When doing a manual sum or using
the AutoSum, whey would my number come out like so 0.00 and not a dash? If
you increase the decimal out there is a number, 0.00000000000000164316543.
?? The number are whole numbers, e.g. 24.25, 100.25, 562.64 ect.

Thanks