I have 250 rows with date in mm/dd/yyyy, how can I change it to dd/mm/yyyy
format.

Tried from FormatCustommm/dd/yyyy, though even after selecting this
option date does not change for the rows

please advise

thanks

That's because the dates are text, you have to make them numbers, what are
the date settings in your regional options/settings in windows control
panel?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Gerald" wrote in message
...
I have 250 rows with date in mm/dd/yyyy, how can I change it to dd/mm/yyyy
format.

Tried from FormatCustommm/dd/yyyy, though even after selecting this
option date does not change for the rows

please advise

thanks

Its English (United Kingdom)

tried changing the field to numbers then Custom dd/mm/yyyy, still does
not change, stays as it is

please help

thanks

"Peo Sjoblom" wrote:

That's because the dates are text, you have to make them numbers, what are
the date settings in your regional options/settings in windows control
panel?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Gerald" wrote in message
...
I have 250 rows with date in mm/dd/yyyy, how can I change it to dd/mm/yyyy
format.

Tried from FormatCustommm/dd/yyyy, though even after selecting this
option date does not change for the rows

please advise

thanks

If they're not changing, it's because XL doesn't recognize them as dates
(i.e., numbers, or integer offsets from the base date). Simply changing
number format doesn't affect Text, since XL doesn't consider Text a
number.

To coerce text to numeric/date try selecting your "dates", then choose
Data/Text to Columns. Click Next, Next, then select "m/d/y" from the
date dropdown and click Finish.


In article ,
Gerald wrote:

tried changing the field to numbers then Custom dd/mm/yyyy, still does
not change, stays as it is

Many thanks, you are a star

"JE McGimpsey" wrote:

If they're not changing, it's because XL doesn't recognize them as dates
(i.e., numbers, or integer offsets from the base date). Simply changing
number format doesn't affect Text, since XL doesn't consider Text a
number.

To coerce text to numeric/date try selecting your "dates", then choose
Data/Text to Columns. Click Next, Next, then select "m/d/y" from the
date dropdown and click Finish.


In article ,
Gerald wrote:

tried changing the field to numbers then Custom dd/mm/yyyy, still does
not change, stays as it is