|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 21st, 2008, 05:00 PM
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
May 21st, 2008, 05:26 PM
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
May 21st, 2008, 06:22 PM
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
May 21st, 2008, 06:22 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
