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.