If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date reverts to numeric format
I have a date in this format May 1, 2009. I’d like to keep it in that format,
but when I concaternate it with another cell, the date converts to a numeric format. How can I prevent this? |
#2
|
|||
|
|||
Date reverts to numeric format
Try the below
=TEXT(A1,"mmm d, yyyy") =TEXT(A1,"mmm d, yyyy") & A2 If this post helps click Yes --------------- Jacob Skaria "ManhattanRebel" wrote: I have a date in this format May 1, 2009. I’d like to keep it in that format, but when I concaternate it with another cell, the date converts to a numeric format. How can I prevent this? |
#3
|
|||
|
|||
Date reverts to numeric format
=TEXT(A1,"mmm d, yyyy")&" the text to which you want it concatenated"
or =TEXT(A1,"mmmm d, yyyy")&" the text to which you want it concatenated" -- David Biddulph "ManhattanRebel" wrote in message ... I have a date in this format May 1, 2009. I'd like to keep it in that format, but when I concaternate it with another cell, the date converts to a numeric format. How can I prevent this? |
#4
|
|||
|
|||
Date reverts to numeric format
Thank you... I appreciate your help.
"David Biddulph" wrote: =TEXT(A1,"mmm d, yyyy")&" the text to which you want it concatenated" or =TEXT(A1,"mmmm d, yyyy")&" the text to which you want it concatenated" -- David Biddulph "ManhattanRebel" wrote in message ... I have a date in this format May 1, 2009. I'd like to keep it in that format, but when I concaternate it with another cell, the date converts to a numeric format. How can I prevent this? . |
Thread Tools | |
Display Modes | |
|
|