why is slash in my date (10/18/07) the / are change to \?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dee - 18 Oct 2007 20:43 GMT

All of a sudden my dates are change the slash direction.... Why? And how do
I fix this?????

Reply to this Message

Chip Pearson - 18 Oct 2007 21:18 GMT

It may have gotten reset by the Control Panel's Regional Settings control.
Too see what Excel is using by default, press ALT F11 to open the VBA
editor, press CTRL G to display the Immediate window, and type the following
and press ENTER.

?Application.International(xlDateSeparator)

This will display the character (typically '/' in US-English) that Excel
uses to separate date elements. If it is not the same, close Excel, go to
the Window Start menu, choose Control Panel, and select "Regional Settings"
or "International Settings" or some such thing (its name varies between
versions of Windows). In that dialog, ensure the proper date separator is
selected.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

> All of a sudden my dates are change the slash direction.... Why? And how
> do
> I fix this?????

Reply to this Message

Dee - 08 Nov 2007 00:42 GMT

You gave me this advise before, it did not work, both of these results showed
/ the correct direction. You sent me further instructions but I did not
understand them. HELP

> All of a sudden my dates are change the slash direction.... Why? And how do
> I fix this?????

Reply to this Message

Dee - 08 Nov 2007 00:43 GMT

Mr. Peterson I have also tried to email you on the web site but it rejects my
request.

> All of a sudden my dates are change the slash direction.... Why? And how do
> I fix this?????

Reply to this Message

Dave Peterson - 08 Nov 2007 00:48 GMT

Please restate what you tried and what failed.

For me, your message is a standalone message. I don't see any of the previous
posts.

ps. Please keep the discussion in the newsgroup. You'll have many more
potential responders.

> Mr. Peterson I have also tried to email you on the web site but it rejects my
> request.
>
> > All of a sudden my dates are change the slash direction.... Why? And how do
> > I fix this?????

Signature

Dave Peterson

Reply to this Message