Date Formats 1

[TheVillan]

Can I pick anybodies brains.

I think I have seen this problem in the long distant past, but am not sure anymore what the solution is.

If you type =today() into a cell, you should see something like 13/02/2003 for a UK machine.

I know that * before a format uses Date and time and regional settings in the control panel.

If they are set to UK, then it should come out like above.

Somebody has a stand alone machine, and swears blind that the control panels settings are set to UK etc.
The problem is that it comes out in the American Format.
The format cells dilaogue box is also set as UK.

This person has put this spreadsheet onto their own laptop and its works fine.

I am just wondering if this would right itself if the Excel regedit was deleted, or is Windows corrupt.

Whatever, if you know of this problem, whats the treatment for it.

Thanks in advance for any help.

Les

 

[xlhelp]

Please look at
thread68-399663 "Age is a high price to pay for maturity."

 

[TheVillan]

XLHelp thanks very much, I have had a look and it could well be the problem. I will let you know how I get on.

One thing, do you have to export each key indiviually or does it take the lot and do it in one go.

Thanks
Les

 

[xlhelp]

You can export the whole registry file or you export individual ones. Choice is yours. In one case it's a huge file size and in the other it's not.

To back up indivual registry, select it, go to File, Export restry and give it a file name. It will export the particular folder containing the key. "10 kinds of people in the world. Those who understand binary numbers and those who don't."

 

[TheVillan]

Thats fine, I saved them indiviually.
Thanks once again.
Les