And if you require that format, you'll have to enter the spaces yourself

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"David Biddulph" <groups [at] biddulph.org.uk wrote in message ...
| Either format the cell as text *before* you enter the data, or precede the
| data with an apostrophe.
| --
| David Biddulph
|
| "ToMMie" wrote in message
| ...
| 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
| |
| |
|
|
|
|
|