software

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

Tried from Formatgt;gt;Customgt;gt;mm/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
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Geraldquot; gt; wrote in message
...
gt;I have 250 rows with date in mm/dd/yyyy, how can I change it to dd/mm/yyyy
gt; format.
gt;
gt; Tried from Formatgt;gt;Customgt;gt;mm/dd/yyyy, though even after selecting this
gt; option date does not change for the rows
gt;
gt; please advise
gt;
gt; thanks
gt;
gt;
gt;
Its English (United Kingdom)

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

please help

thanks

quot;Peo Sjoblomquot; wrote:

gt; That's because the dates are text, you have to make them numbers, what are
gt; the date settings in your regional options/settings in windows control
gt; panel?
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Excel 95 - Excel 2007
gt; Northwest Excel Solutions
gt; www.nwexcelsolutions.com
gt; quot;It is a good thing to follow the first law of holes;
gt; if you are in one stop digging.quot; Lord Healey
gt;
gt;
gt; quot;Geraldquot; gt; wrote in message
gt; ...
gt; gt;I have 250 rows with date in mm/dd/yyyy, how can I change it to dd/mm/yyyy
gt; gt; format.
gt; gt;
gt; gt; Tried from Formatgt;gt;Customgt;gt;mm/dd/yyyy, though even after selecting this
gt; gt; option date does not change for the rows
gt; gt;
gt; gt; please advise
gt; gt;
gt; gt; thanks
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

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 quot;datesquot;, then choose
Data/Text to Columns. Click Next, Next, then select quot;m/d/yquot; from the
date dropdown and click Finish.In article gt;,
Gerald gt; wrote:

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

Many thanks, you are a star

quot;JE McGimpseyquot; wrote:

gt; If they're not changing, it's because XL doesn't recognize them as dates
gt; (i.e., numbers, or integer offsets from the base date). Simply changing
gt; number format doesn't affect Text, since XL doesn't consider Text a
gt; number.
gt;
gt; To coerce text to numeric/date try selecting your quot;datesquot;, then choose
gt; Data/Text to Columns. Click Next, Next, then select quot;m/d/yquot; from the
gt; date dropdown and click Finish.
gt;
gt;
gt; In article gt;,
gt; Gerald gt; wrote:
gt;
gt; gt; tried changing the field to numbers then Custom gt;gt;gt; dd/mm/yyyy, still does
gt; gt; not change, stays as it is
gt;