converting date to text

S

SallyP

Hi ,
I would like to convert my date which is formatted as mm/dd/yy to a text
format but i dont want to change the way the date looks. Currently every time
i convert it to a text the date turns into a number.

Can someone help me please
 
G

Gord Dibben

I guess you missed my reply yesterday to your same question.

In a helper column................

=TEXT(A1,"mmmm-dd-yyyy")

You choose the format within the double quotes

Copy and paste special(in place)>values>ok>esc

Delete column A

Or copy and paste special(onto column A)


Gord Dibben MS Excel MVP
 

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

Converting general text format to date 6
date 2
Date Format 9
Converting a date to text..Format question 2
Preserving date format 1
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Convert military date system to standard date system 8
Columns formatted As Dates Are Exported as a Number to Text 1

Top