Convert Date format to Text

[DuncanH]

How do I convert an excel cell image in dd-mmm-yyyy format
to a new cell in pure text format to read dd-mmm-yyyy?
Using DATA/TEXT TO COLUMNS/TEXT gives me the equivalent
numerical value for the date eg 01-Feb-2003 gives text of
01/02/2003

 

[Norman Harker]

Hi Duncan!

Use:

TEXT(A1,"dd-mmm-yyyy")

This returns the date serial number as text in the format provided by
the second argument.

--
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.

 

[DuncanH]

Hi Norman
Thanks for the solution, it worked just fine. Obvious
really - if you know.
By the way, what are you doing answering these questions
at 3-40am?
You mentioned in your signature block availability of
excel and word function lists. I would be most interested
if you can mail a set to (e-mail address removed)

Thanks again

 

[Norman Harker]

Hi Duncan!

Have sent Function Lists as requested.

It wasn't 3:40AM. It was 10:40 PM. Sydney is Zulu -11 hours at present
with clocks going back 1 hour this coming weekend (I think).

But it's not unusual for me to work late or early even though I don't
get anywhere close to Frank's hours.


--
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.