Lock in formatting
 

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

Instead of Copy/Paste, try Copy/Paste Special:

On the source worksheet, Copy the cells.
On the destination worksheet, select the cell you want to paste the numbers
into, then:
EditPaste Special
Select Values
Click [OK]

That way only the numbers will be pasted, not their formats.

Does that help?
Ron


"Derek Y via OfficeKB.com" wrote in message
...

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

It works, but i'm copying and pasting like 20-30 sets of data per merge...so
it becomes very tedious. OHHHHHHHH i'll just write a macro thats like ctrl B
or something. Cool thanks :)

Ron Coderre wrote:
Instead of Copy/Paste, try Copy/Paste Special:

On the source worksheet, Copy the cells.
On the destination worksheet, select the cell you want to paste the numbers
into, then:
EditPaste Special
Select Values
Click [OK]

That way only the numbers will be pasted, not their formats.

Does that help?
Ron

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

[quoted text clipped - 16 lines]

Thanks


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