Another option: Data Text to Columns Next Next Text Finish

"Lori" wrote:

Select the column then try this:
- Press Ctrl+C twice and click the Paste clipboard Icon
- Format Cells Text OK
- Edit Paste Special Text OK

(To convert all data to text select the whole sheet instead.)

"Michele" wrote:

I have a column of dates, formatted as dd/mm/yyyy. I need these cells to be
formatted as text as I need to export and upload this information to another
program. If I merely format the cells as text, I get a numeric code. I need
that to read as a date dd/mm/yyyy, but in a cell formatted as text. Help!