Changing dates
=text(a1,"mmddyy")
if A1 contained the date
Or just format the cell using a custom format:
mmddyy
MICHALK wrote:
How do you change a date to text and return a string such as mmddyy to
replace 01/01/10? In other words remove the slashes but keep the same
numbers.
--
Dave Peterson
|