Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date reverts to numeric format
I have a date in this format May 1, 2009. Id 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. Id 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resetting cell format from TEXT to NUMERIC and DATE | Excel Discussion (Misc queries) | |||
E-mailed worksheet reverts date | Excel Discussion (Misc queries) | |||
Excel - CSV file, trying to save a date as text, reverts back to d | Excel Worksheet Functions | |||
Date in numeric format | New Users to Excel | |||
Date in numeric format | New Users to Excel |