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"
