Hi,
when I key in numbers more than..say 16 digits, I get as 1.65E+
when I convert the cell content to a number, it gives different number totally.
For example..
I try to key in 123456789987654321
I get a display as 1.23457E+17
when I convert the above as number it gives it as 123456789987654000.00
Is there a way to key in the above long digit in the way we want...in first shot..
OR
If I convert, ist it posisble to get them back as actual keyed in numbers ?
Thanks
Shad
Bookmarks