Copying the number of a custom formatted number cell
 

I've formatted column A with a custom: 5100# so that when I type a number
in the column it adds the 5100 in front of the number I typed. Now I want to
copy the new formatted numbers into column B with the 5100 in front of it. I
can't get it to keep the formatting and when I paste, it only pastes the
number I typed without the 5100 in front of it. Is there an easy way to do
this?

Copying the number of a custom formatted number cell
 

=5100&A1
--
David Biddulph

"fbvideo" wrote in message
...
I've formatted column A with a custom: 5100# so that when I type a
number
in the column it adds the 5100 in front of the number I typed. Now I want
to
copy the new formatted numbers into column B with the 5100 in front of it.
I
can't get it to keep the formatting and when I paste, it only pastes the
number I typed without the 5100 in front of it. Is there an easy way to
do
this?

Copying the number of a custom formatted number cell
 

Thanks!

"David Biddulph" wrote:

=5100&A1
--
David Biddulph

"fbvideo" wrote in message
...
I've formatted column A with a custom: 5100# so that when I type a
number
in the column it adds the 5100 in front of the number I typed. Now I want
to
copy the new formatted numbers into column B with the 5100 in front of it.
I
can't get it to keep the formatting and when I paste, it only pastes the
number I typed without the 5100 in front of it. Is there an easy way to
do
this?