Shortcut for "Ctrl+Shift+1"

[Guest]

When I hit "Ctrl+Shift+1" with Excel 97, it changed cell format to two
decimal with thousand comma. I upgraded to Excel 2003 recently and I found
out that this shortcut is working properly. Now it changed to no decimal with
thousand comma.
Is there any way I change back to before?
Thanks.

 

[Gord Dibben]

that this shortcut is working properly.

Assume a typo and "not working" is what you meant.

I cannot replicate your problem with Excel 2003.

CTRL + SHIFT + 1 gives me thousands comma and two DP.

I have tried changing Style under Format, changing my regional options in
control panel but no can do.

12345 turns out as 12,345.00

But hang in, someone out there may have something for you.


Gord Dibben MS Excel MVP

 

[Jim Rech]

What's weird about this is that I prefer no decimal place so in my
Personal.xls I've redefined this shortcut to apply no decimal places. It's
almost as if you're using my Personal or at least have a macro changing the
shortcut.

If you start Excel via Start->Run with "Excel.exe /s" (no quotes) and you
get 2 decimal places, as you should, then you know there is a macro changing
the keystroke. Starting Excel with /s puts it in 'safe mode' with no
workbooks or add-ins loading automatically, so you get pure Excel.

--
Jim
| When I hit "Ctrl+Shift+1" with Excel 97, it changed cell format to two
| decimal with thousand comma. I upgraded to Excel 2003 recently and I found
| out that this shortcut is working properly. Now it changed to no decimal
with
| thousand comma.
| Is there any way I change back to before?
| Thanks.