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)
--
Gary''s Student - gsnu2007k


"ben" wrote:

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.

Gary''s Student wrote:
For 12 digit numbers:

0000 0000 0000

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

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

--
Regards
Roger Govier

"ben" wrote in message
...
Gary''s Student wrote:
For 12 digit numbers:

0000 0000 0000

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

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?

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.
--
John C


"ben" wrote:

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.

Sorry, forgot you wanted spaces
'1234 5678 9012 3456

--
Regards
Roger Govier

"ben" wrote in message
...
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.