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
|