Converting a date to a non date format

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

I need to convert 12/18/2003 to 12.18.2003. I cannot use
a customer format to do this so what code would be able to
do this?


Thanx

Todd Huttenstine
 
I need to convert 12/18/2003 to 12.18.2003. I cannot use
a customer format to do this so what code would be able to
do this?


Thanx

Todd Huttenstine
Click to expand...


With the date in A1: =TEXT(A1,"mm.dd.yyyy")


--ron
 
Hi Todd!

One way:
=TEXT("18-dec-2003","mm.dd.yyyy")

Note that your date has to be in a format recognised as a date by your
Regional Settings and must be in quotations. You could ensure that
this is recognised using:

=TEXT(DATE(2003,12,18),"mm.dd.yyyy")

Better still if the date is in a separate cell such as A1

=TEXT(A1,"mm.dd.yyyy")

But in all cases note that the date is now in a text form and that
might impose limitations that the custom format rout wouldn't have.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top