MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date as Text


Posted by Jeremy on January 11, 2001 1:24 PM

How do I automatically change a date to text?

Basis for question: I have created a database that copies information from a worksheet and stores it on another worksheet within the same workbook. On the data-entry form, there is a section for an automatic date [ =Today() ]. The formula says to copy and paste that date onto another worksheet. My question is how do I automatically paste the date so that it is entered as text? Any help would be great!! Thanks in advance.


Posted by Mark W. on January 11, 2001 2:42 PM

Did you try changing =TODAY() to:

=TEXT(TODAY(),format) where

format is a valid date format
(enclosed by quotes) such as:

"mm/dd/yy"
"dd-mmm-yy"
"mmmm, yyyy"