Convert special number to text, retain formatting

[MJSpartz]

I need to export out of excel into another database. I have a phone number that is a "special" format. I want to keep that formatting but make it text only for the export

I have done this before and can't remember what I did. If memory serves me correctly, It was a simple formula that I ran, copied the column, did a paste special into another column as values and it worked

Thanks in advance for any assistance.

 

[Frank Kabel]

Hi
use the TEXT function for this. e.g.
=TEXT(A1,"your_format")