| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
(1,100.00) hot key ?
Is there a shortcut key so that I can get a number to appear as (5,444.00) ?
Driving me crazy :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
(1,100.00) hot key ?
Make sure your View-Toolbars-Formatting menu is on, then you just click the
icon of a comma. -- -John Please rate when your question is answered to help us and others know what is helpful. "SnowLeopard" wrote: Is there a shortcut key so that I can get a number to appear as (5,444.00) ? Driving me crazy :) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
(1,100.00) hot key ?
I assume that you want all numbers to appear in that (,) format. You have to
format all cells you think you will use with those number and go to custom and type in (#.00) and press enter. Hope this helps. "SnowLeopard" wrote: Is there a shortcut key so that I can get a number to appear as (5,444.00) ? Driving me crazy :) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
(1,100.00) hot key ?
Small mistake enter this in the custom: (#,###.00)
"SnowLeopard" wrote: Is there a shortcut key so that I can get a number to appear as (5,444.00) ? Driving me crazy :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
