number format for a cell

  • Thread starter Thread starter ben
  • Start date Start date
B

ben

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.
 
For 12 digit numbers:

0000 0000 0000

For 16 digit numbers use a Text format ( 15 digits is the max for numbers)
 
When you copy a cell, and paste it (CTRL+C then CTRL+V), you not only copy
the cell contents, but you are also copying cell formatting including
conditional formatting. If you Paste Special-->Values, then it shouldn't copy
your formatting and it should just display the numbers as you are wanting.
(keyboard shortcut, ALT, E, S, V).

Hope this helps.
 
Gary''s Student said:
For 12 digit numbers:

0000 0000 0000

For 16 digit numbers use a Text format ( 15 digits is the max for numbers)
Click to expand...

I meant 16 digit number actually and that must be my problem. Thanks.

I presume formating the text to have spaces is not possible then?
 
Hi Ben

For 16 digits, you need to either pre-format the cell as text, or use an
apostrophe before your number to make it a text entry
'1234567890123456
 
Back
Top