View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default how to write 1234567890123456789 into a cell with number format

Hi,

preceed the input with '

or format as text

Mike

"Anila" wrote:

I want to enter more than 16 digits into a cell in number format (the number
should not converted to exponential format). The digits from 16th digit are
being converted to zeros. How to avoid it