Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
why is slash in my date (10/18/07) the / are change to \?
All of a sudden my dates are change the slash direction.... Why? And how do
I fix this????? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
why is slash in my date (10/18/07) the / are change to \?
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. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Dee" wrote in message ... All of a sudden my dates are change the slash direction.... Why? And how do I fix this????? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
why is slash in my date (10/18/07) the / are change to \?
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 "Dee" wrote: All of a sudden my dates are change the slash direction.... Why? And how do I fix this????? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
why is slash in my date (10/18/07) the / are change to \?
Mr. Peterson I have also tried to email you on the web site but it rejects my
request. "Dee" wrote: All of a sudden my dates are change the slash direction.... Why? And how do I fix this????? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
why is slash in my date (10/18/07) the / are change to \?
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. Dee wrote: Mr. Peterson I have also tried to email you on the web site but it rejects my request. "Dee" wrote: All of a sudden my dates are change the slash direction.... Why? And how do I fix this????? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing A Row Header Containing a Slash | Excel Discussion (Misc queries) | |||
Where do I get the slash sign for Excel? | Excel Discussion (Misc queries) | |||
How do I make a zero appear with a slash | Excel Discussion (Misc queries) | |||
Zero with a slash | Excel Discussion (Misc queries) | |||
How can I put a slash in a zero in Office 97 | New Users to Excel |