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?