View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 12 digit number rounding down why?

You sure it is only 12 digits?

Excel will add a zero after 15th digit.

Never seen after 12 digits.


Gord Dibben MS Excel MVP

On Wed, 17 Mar 2010 06:00:01 -0700, Lyd
wrote:

12 digit number entered with cell formatted as just a number is rounding to
end in zero all the time. Help please. cell is not locked