Lock in formatting

  • Thread starter Derek Y via OfficeKB.com
  • Start date
D

Derek Y via OfficeKB.com

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
 
R

Ron Coderre

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:
Edit>Paste Special
Select Values
Click [OK]

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

Does that help?
Ron
 
D

Derek Y via 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 said:
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:
Edit>Paste 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....
Click to expand...
[quoted text clipped - 16 lines]
Thanks
Click to expand...
Click to expand...
 
Top