| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell as custom type but data doesn't display like I custom.
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell as custom type but data doesn't display like I custom.
Hi ToMMie,
The longest integer you can input as a number is 15 digits. -- Cheers macropod [MVP - Microsoft Word] "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell as custom type but data doesn't display like I custom.
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 | | |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell as custom type but data doesn't display like I cus
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 | | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | | |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell as custom type but data doesn't display like I cus
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 | | | | | | | | | |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell as custom type but data doesn't display like I cus
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. -- Cheers macropod [MVP - Microsoft Word] "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 | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom number display format | Excel Worksheet Functions | |||
| Excel Format Cells - Number Tab - Custom - Order of Type Window. | Excel Discussion (Misc queries) | |||
| How do I display custom file properties in a cell | Excel Discussion (Misc queries) | |||
| Format cells, custom type, delete | Excel Discussion (Misc queries) | |||
| Why does Custom Format not control Cell Display? | Excel Discussion (Misc queries) | |||
Hybrid Mode
