Ctrl+Shift+! for two decmial places with thousand separator

[Ken NX]

Hi everyone
I'm doubted with something
when i key in a number in a new worksheet, sound like 12300 ENTER, it showed
"12300". then when i highlight and press CTRL+SHIFT+!, the format changed to
"12,300.00" when i was using Excel 2000pro

but when i upgraded to 2003standard, it changed to "12,300", the two
decimals places didnt come out, it was also the same when i changed to 2007pro

my problem is: when i press CTRL+SHIFT+!, i want my 2007pro to
show "12,300.00", it has been a problem for me for years....

the version of my OS is Win XP CHT

regional and language setting:

Regional option->
Standard and Format: English(US)
Location: English (US)

Language->
Text service and inputing language -> details -> advanced -> TICKED extended
support for advanced text service for all programs

 

[DazzaData]

Why not just write a short macro

Activecell.format....

you could define your own shortcut such as CTRL ! to run it at anytime

 

[Ken NX]

hi Dazzadata, thanks for your reply
but i know nothing about macros, could you show me how? thanks