Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Date format using space as date separator rather than forward slash!


07 Nov 2010   #1

Windows 7 Home Premium 32-bit
 
 
Date format using space as date separator rather than forward slash!

Hi all,

I'm new to Windows 7 (Home Premium 32-bit) and I just can't figure out what's going on here! Basically I want my short date format to be dd/mm/yyyy (UK format) e.g. 05/11/2010, but when I key a date into Excel 2002 it is appearing as 05 11 2010. In Control Panel I have the short date format set to ddd dd/MM/yyyy and the example is shown as Fri 05/11/2010, but in Excel all the date formats are shown with space separators, e.g. 14 03 2001! I don't think it's an Excel problem though as in Windows Task Scheduler the dates are shown with spaces there e.g. '19:25 on Mon 01 11 2010'. The date by the clock though is shown correctly with slash separators!

I know in Windows XP you can select the date separator from a drop-down list, but this option seems to be absent in Windows 7. Under HKEY_CURRENT_USER\Control Panel\International in the registry, sDate was set to a space, but changing that to a slash (and rebooting) didn't fix the problem.

Does anyone have any ideas please what's wrong and how to fix it?

Thanks
Steven


My System SpecsSystem Spec
.

07 Nov 2010   #2

 
 

Hi,

The option you're after is controlled from within Excel. If you right-click the cell(s) in question you can select 'format cells' and under 'Date' you can select the desired format.


OS
My System SpecsSystem Spec
07 Nov 2010   #3

 
 

Can you not make a custom date format? e.g. using "dd/mm/yyyy"
My System SpecsSystem Spec
.


07 Nov 2010   #4

Windows 7 Home Premium 32-bit
 
 

Quote   Quote: Originally Posted by Orbital Shark View Post
Hi,

The option you're after is controlled from within Excel. If you right-click the cell(s) in question you can select 'format cells' and under 'Date' you can select the desired format.


OS
Thanks, but ALL the date formats in Excel use space separators instead of slashes! Also like I said the Windows Task Scheduler is using space separators too, so it's ignoring the registry setting
My System SpecsSystem Spec
07 Nov 2010   #5

Windows 7 Professional SP1 64-bit
 
 

It doesn't matter what you do in the registry. The date format is controled from within Excel, which is not a part of Windows 7. I was able to set the date in Excel 2010 by right-clicking the cell, as Obital instructed, and selecting format cell. I set the location to English (U.K.) and selected the first option.
My System SpecsSystem Spec
07 Nov 2010   #6

Windows 7 Professional 64 Bit SP1
 
 

Apparently Excel 2002 has a custom date format: Custom Date Format Excel 2002 | TheDailyReviewer

I haven't used Excel 2002 in a long time, but I know that in Excel 2007 you just select the fields you want, choose to format the cells, then you can click 'custom' and input your date format required.

Also, your other programs may be reading your long date format, not the short one.

Quote   Quote: Originally Posted by CiaraJansonFan View Post
Quote   Quote: Originally Posted by Orbital Shark View Post
Hi,

The option you're after is controlled from within Excel. If you right-click the cell(s) in question you can select 'format cells' and under 'Date' you can select the desired format.


OS
Thanks, but ALL the date formats in Excel use space separators instead of slashes! Also like I said the Windows Task Scheduler is using space separators too, so it's ignoring the registry setting
My System SpecsSystem Spec
07 Nov 2010   #7

 
 

See if the following steps will help,

Open Control Panel -> Clock, Language, and Region -> Region and Language

1, Under 'Formats' make sure that English - (United Kingdon) is selected

Name:  1 Region - Formats.PNG
Views: 16
Size:  56.3 KB

2, Under 'Location' make sure that United Kingdom is selected

Name:  2 Region - Location.PNG
Views: 7
Size:  48.1 KB

3, Under 'Keyboard and Languages' and 'Change Keyboards' make sure that the 'Default Input Device' is set to English (United Kingdom) - United Kingdom

Name:  3 Region - Keyboards.PNG
Views: 6
Size:  41.3 KB

4, Under 'Administrative' click 'Copy Settings'. Make sure that both settings at the bottom are selected and click 'OK'

Name:  4 Region - Copy Settings.PNG
Views: 9
Size:  53.7 KB

Now try in Excel to see if it has had any effect.

Note   Note
This has helped in gaining additional settings from within certain application within Windows



OS


My System SpecsSystem Spec
07 Nov 2010   #8

Windows 7 Home Premium 32-bit
 
 

Quote   Quote: Originally Posted by Petey7 View Post
It doesn't matter what you do in the registry. The date format is controled from within Excel, which is not a part of Windows 7. I was able to set the date in Excel 2010 by right-clicking the cell, as Obital instructed, and selecting format cell. I set the location to English (U.K.) and selected the first option.
What's the format for the first example then please? Mine are as follows:

*14 03 2001
*Wed 14 Mar 2001
14 03 2001
14 03 01
14 3 01
14.3.01
2001-03-14

As you can see, none of these have slash separators!

If I boot up into XP (same version of Excel), the separators are shown as slashes:

*14/03/2001
14/03/2001

etc.

Thanks
Steven
My System SpecsSystem Spec
07 Nov 2010   #9

Windows 7 Home Premium 32-bit
 
 

Orbital,

No effect whatsoever I'm afraid! Both Task Scheduler and Excel are still showing space separators. I've also checked my netbook running Windows 7 Starter and the Task Scheduler on that is the same. Can you check your Task Scheduler please and let me know how the dates are formatted?

Mine is attached.

Thanks
Steven


Attached Images
 
My System SpecsSystem Spec
07 Nov 2010   #10

Windows 7 Professional SP1 64-bit
 
 

Mine show as:
14/03/2001
14/03/01
14/3/01
14. 3. 01.
2001-03-14

It seems unusual that you would randomly show spaces instead of slashes. For the time being I recommend uninstalling Office completely then reinstalling it, incase something went wrong during the install process. Also, what are you typing when you enter the date (i.e. =now(), =date(year,month,day), or just typing it in as 14/03/2001).
My System SpecsSystem Spec
Reply

 Date format using space as date separator rather than forward slash!




Thread Tools



Similar help and support threads for2: Date format using space as date separator rather than forward slash!
Thread Forum
Date Format - Change Tutorials
File search (by date range) displays incorrect Mod Date in results General Discussion
event log: format of date and time General Discussion
Solved How to change date separator General Discussion
Forward - Backward Slash? General Discussion
UK date format in Windows 7 RC General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:59 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33