Obviously one or other of us is confused, Rich. My understanding was that
custom format can alter the way the date is displayed, but not alter the
date itself. If he is seeing 1-Feb-07 then your custom format of DD MMM YY
will change the display to 01 Feb 2007. The *format* won't change his date
to 2-Jan-07. We'll wait to see whether your suggestion works for the OP,
but I would doubt it.
--
David Biddulph

"Rich Mcc" (no spam) wrote in message
...
dave ,,

but since his date is already showing as a date format 1-Feb-07 all he
needs to do is alter the custom settings to show the date in the order he
requries,,

simply put both ways will work ,, depending on what the problem is, the
way
you would fix the problem and i would are both effective ,,

"David Biddulph" wrote:

I don't think you read the OP's question, Rich. If when he formats the
cell
it comes up as 1-Feb-07 then the contents of the cell must be 39114,
while
he intended 39084, so your custom format will not give the result he
wants.
This may have occurred because of the Windows Regional settings.
The easiest cure for the existing data is Data/ Text to Columns/
Delimited/
through to last stage:
Date format: DMY.
--
David Biddulph

"Rich Mcc" (no spam) wrote in message
...
format cell : custom

DD MMM YY

"cab_cool" wrote:

how to I change the dates from american to australian
2/1/07 is comes up as 1-Feb-07 but if I want to change it goes
Feb-1-07
if I
open up Format/Cells and change it. I want it to come up as 2-Jan-07
so
how
do do this how do I change it.