Convert special number to text, retain formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
use the TEXT function for this. e.g.
=TEXT(A1,"your_format")
 
You must log in or register to reply here.

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

Which is the best MBOX Converter Tool different formats conversion? 4
How to Export Gmail Emails to PST Format? 4
How to Convert EML to PST? 2
Copy column, paste special formulas & number formats doesn't work 3
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Format - Text to Number or vice versa 1
Paste Special Values 2
How can we convert OST to PDF file format? 1

Back
Top