Forum Home
Press F1
 
Thread ID: 53387 2005-01-16 05:30:00 excel problem also keyboard. peter pan (6885) Press F1
Post ID Timestamp Content User
314698 2005-01-16 05:30:00 Gi Day I have just got a new pc running xp home and office 2000 profesional.

problem 1 is that using excel I am unable to change the date from US Format to UK format I have tried format cells then chosen the day month but it always comes up US format

problem 2 when entering my email address and clicking on the@key on my keyboard I get the " sign To get the@ sign i have to go to he " key. hope you can follow what I am about and mabe get ba fix for the 2 problems.

by the way I have a new cordless mouse and keyboard I have tried my old keyboard and mouse and problems are still there. :mad:
peter pan (6885)
314699 2005-01-16 05:38:00 Try changing the language in control panel / regional and language options.

To English UK, if ur in the UK. And location to United Kingdom as well.
Speedy Gonzales (78)
314700 2005-01-16 05:40:00 problem 2 when entering my email address and clicking on the@key on my keyboard I get the " sign To get the@ sign i have to go to he " key . hope you can follow what I am about and mabe get ba fix for the 2 problems .
This is because you've selected the UK keyboard layout .

Control Panel --> Regional Language

In the regional options tab, select English New Zealand (this might fix teh date issue as well) .

Then select the Language tab, click details, and select a US keyboard in there .
ninja (1671)
314701 2005-01-16 05:45:00 problem 2 when entering my email address and clicking on the@key on my keyboard I get the " sign To get the@ sign i have to go to he " key. hope you can follow what I am about and mabe get ba fix for the 2 problems.
I have a Microsoft keyboard,to change the keys I go to keyboard quick start guide,this facilty came with disc.
Cicero (40)
314702 2005-01-16 06:44:00 On XL 2000 pro there are further Date Formats under “Custom” that may be of help. B.M. (505)
314703 2005-01-16 07:16:00 nija thanks for the fix for keyboard ok now

still have the excel problem with the date

wrinkly tried the custom fix with no luck .by the way I`m just over the bridge
peter pan (6885)
314704 2005-01-16 07:34:00 nija thanks for the fix for keyboard ok now

still have the excel problem with the date

wrinkly tried the custom fix with no luck .by the way I`m just over the bridge
Give Wendy a try,she may help.
Cicero (40)
314705 2005-01-16 19:07:00 OK, what format do you want the date in? (dd/mm/yy?) B.M. (505)
314706 2005-01-17 04:14:00 Wrinkley I would like my date to be day month, Now when formatted to day month ie 14 march and i enter 14/3 then that is what is shown not 14 march, I have tried 14\3 but same result.Only when the first number is below 12 do you get the month but in the reverse order ie 12/3 comes up 3rd dec. same with custom.With my old pc I could change my formatting without any trouble. must be a setting somewhere peter pan (6885)
314707 2005-01-17 05:32:00 Oh dear!

14/3 works fine on mine . (14th March)

OK, given your other problems how about going: Help - Detect & Repair .

You may get asked for you disk in this procedure, but it will check that the installation is correct .
B.M. (505)
1