Numeric entry

M

Madhav

I am not able to keep big numeric as it is eg (0007001179000379822) whenever
i put it it coverts to exp or if i change it to custom formated the number is
changed to 0007001179000379820 how do i keep the number as it is
 
B

Bondi

Madhav said:
I am not able to keep big numeric as it is eg (0007001179000379822) whenever
i put it it coverts to exp or if i change it to custom formated the number is
changed to 0007001179000379820 how do i keep the number as it is
Click to expand...

Hi,

You can format the cell as Text befor you enter the number. I think
there is something about Excel not able handle more than 15 digits.

Some information on this link:

http://support.microsoft.com/?scid=kb;en-us;269370

Regards,
Bondi
 
Top