Hi Niek Otten,

Can you please tell me how to enter them as text with the format I want? I
don't need to do the calculation with these data.

Many thanks in advance.
ToMMie

"Niek Otten" wrote:

Excel's precision is only 15 decimal digits.
If you need more you'll have to enter them as text, but then you can't calculate with them anymore

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ToMMie" wrote in message ...
|I format the cell as custom type like 0000 0000 0000 0000 in order that the
| number the user key in the cell 1111222233334444 (without space) will display
| like 1111 2222 3333 4444 automatically.
|
| But the problem is when I key in 1111222233334444 the last number always
| becomes ZERO at all time like 1111 2222 3333 4440.
|
| How can I fix that? Could you please help me?
|
| Many thanks.
| ToMMie
|
|