Copying text contents of cell A

guest

Board Regular
Joined
Feb 21, 2002
Messages
91
when i copy contents of sheet xyz and column A it has all numbers in it, when i see properties it says text. When i copy the whole column A and make a new sheet and paste the contents in column a of new sheet and try to make custom format of all the selected cells as 0000000000, when i am doen with this the cells do not reflect the new format until i edit that field.
Any idea how i can do it without editing the field ?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

wob

Board Regular
Joined
May 21, 2002
Messages
105
think i can help...

copy the cells, then right click and choose paste special, then values over the cells that you have pre-custom formated.

that do it?
 

Forum statistics

Threads
1,144,363
Messages
5,723,919
Members
422,527
Latest member
JayTheKaz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top