| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctrl+Shift+! for two decmial places with thousand separator
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ctrl+Shift+! for two decmial places with thousand separator
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" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ctrl+Shift+! for two decmial places with thousand separator
hi Dazzadata, thanks for your reply
but i know nothing about macros, could you show me how? thanks "DazzaData" wrote: 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" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shift option ctrl etc | Excel Discussion (Misc queries) | |||
| thousand separator conversion from dot to comma | Excel Discussion (Misc queries) | |||
| thousand separator | Setting up and Configuration of Excel | |||
| thousand separator as indian style for negative number | Excel Discussion (Misc queries) | |||
| Ctrl+Shift+arrow | Excel Worksheet Functions | |||
Linear Mode
