Format Cell as custom type but data doesn't display like I cus
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
|
|
|