date format

G

Gerald

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

Tried from Format>>Custom>>mm/dd/yyyy, though even after selecting this
option date does not change for the rows

please advise

thanks
 
P

Peo Sjoblom

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
 
G

Gerald

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
 
J

JE McGimpsey

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

Gerald

Many thanks, you are a star

JE McGimpsey said:
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.
Click to expand...
 
Top