Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hello,
I want to store a 12 digit number in a some cells. Ideally, I'd like it with a space after every 4th number and such that when I copy and paste to other applications there is no space in between. I tried doing a custom format set to "#### #### #### ####" but had some serious problems with that. Firstly, the last number for some reason would change itself to '0' and another problem I had was that pasting the number would maintain the spaces even though it was only there in the formating and not in the way the number was stored. Can anyone give me some guidance on this. Thanks you very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format cell to Number | Excel Discussion (Misc queries) | |||
Number format in cell changes | Excel Discussion (Misc queries) | |||
Cell Number format | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
CELL/NUMBER FORMAT | Excel Discussion (Misc queries) |