Hello from Steved

I thankyou all and I will try out the examples that I have be given

Cheers.

"michaelas" wrote:


steved
I may be misinterpreting your intention, but you can go to
Format/Cells/Numbers/Custom and select d-mmm-yy (in WIN XP). After that
if you simply type 12/8 it will read out as 8-Dec-05. The default
setting for Excel comes from the control panel to read the month
first.

Alernatively, you can try this:
Control Panel/Regional Settings/Customize/Click Date Tab/set short date
format to dd-mmm-yyyy

Hope that helps

michaelas


--
michaelas
------------------------------------------------------------------------
michaelas's Profile: http://www.excelforum.com/member.php...o&userid=26573
View this thread: http://www.excelforum.com/showthread...hreadid=467020