I read a thread about this but he had a bit of a different situation....

I want to copy and paste into a column about 2000 numbers. The numbers are
in another excel sheet as 100000,125000 etc etc. no commas no $ nothing.
And i need them to stay that way in that excel sheet. When i copy them over
to this other excel sheet, I want them to be in the format $125,000. But
even if i tell that column to be in that format when i copy and paste the
data over it reverts back to 125000 and i have to re-tell that column that i
want it in $125,000. Any way to just lock this in so i can constantly copy
and paste data into this column and have it automatically formatted?....I
know I could just create a helper column that I dont touch that ='s the other
column's data (the one i pasted into) but has the proper formatting....but
I'd rather not.

Thanks


--
Message posted via http://www.officekb.com