make custom formatting permanent

S

simha

I have a column in which I have custom formated about 50 cells to add
prefixes, a name such as <"Developer -"@ > Developer-Peter instead of just
Peter, Accountant-John instead of John. Now I want to make this custom
formating permanent. I have tried using paste-special and pasted it to a
different cell but unfortunately the custom formating remains and all what
is copied is the original cell data that is just Peter or John instead of
custom prefixes.

Any idea on how to make the custom formating static in the same cell or a
different cell??

Thanks in advance
Simha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Formatting changes 3
Custom formatting to force a decimal place 3
How to make web image on Excel worksheet permanent 3
EOMONTH, TODAY() and Conditional Formatting (Excel 2003) 1
conditional formatting 1
Prevent paste from re-formatting cell 4
Conditional Formatting for times 1
Custom Cell Format - Revisited 3

Top