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.

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.

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.

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.

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.

I'm with you David.

Change the Regional settings for future and clean up existing dates with your
Text to Columns method.


Gord Dibben MS Excel MVP

On Sat, 17 Feb 2007 20:44:06 -0000, "David Biddulph"
wrote:

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.

Thank You David Biddulph, Rich Mcc I had already tried format cell : custom

"David Biddulph" wrote:

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.

not a probem, confused is a permanant state of mind so no real suprise their

"cab_cool" wrote:

Thank You David Biddulph, Rich Mcc I had already tried format cell : custom

"David Biddulph" wrote:

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.