entering numbers in excel
But it will be treated as text. Excel's precision (for numbers, that is) is 15 decimal digits
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Gary''s Student" wrote in message
...
| Precede the number with a single quote (apostrophy).
| --
| Gary's Student
|
|
| "vkwd7" wrote:
|
| when I tried to enter number 123456789101112,the last digit ie 15th digit
| changes to 0 instead of 2.It happens with every number with morethan 14
| digits.
| I tried regional settings which seem ok to me.
| Is there a way out to enter number as number without using the text
| formatting.
| vkwd7
|
|