Thread: Automatic Rounding up
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NN[_2_] NN[_2_] is offline
external usenet poster
  
Posts: 2
Default Automatic Rounding up
In Excel while writing a 16 digit number the last digit is always rounded to
"0". Eg. while writing the number 4030020530156015, the display number is
4030020530156010. Why? however a 15 digit number is displayed as such.
--
NN
Reply With QuoteReply With Quote