Format Cell as custom type but data doesn't display like I custom.

[ToMMie]

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

 

[macropod]

Hi ToMMie,

The longest integer you can input as a number is 15 digits.

 

[Niek Otten]

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

|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
|
|

 

[ToMMie]

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

 

[David Biddulph]

Either format the cell as text *before* you enter the data, or precede the
data with an apostrophe.

 

[Niek Otten]

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
|
| | > 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
| >>
| >> | >> |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
| >> |
| >> |
| >>
| >>
| >>
|
|

 

[macropod]

Hi ToMMie,

Simply enter the data with the required format - including the spaces. If you do that, there's no need to prefix the data with an
apostrophe.