Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Custom number format
Im using excel 2007 and format number cells by doing the following:
Right click a range and select 'format cells' - Select 'number' - decimal places = 0 and 'use 1000 seperator' Can I not create a shortcut somewhere that I can click to automatically format the number cells with a specific criteria? Thanks, Grant |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Custom number format
See if this help
Select the range of Numbers In the formatting tool bar click on the " , " "comma symbol" which is to the right of % symbol on the formatting tool bar. this will give you 2 decimal places. reduce the decimal places by clicking the .00 decrese decimal button, which is to the right of the % symbol on formatting tool bar a long method but may be of help. but you process can be over in 2 to 3 mouse clicks Claude "Grant" wrote: Im using excel 2007 and format number cells by doing the following: Right click a range and select 'format cells' - Select 'number' - decimal places = 0 and 'use 1000 seperator' Can I not create a shortcut somewhere that I can click to automatically format the number cells with a specific criteria? Thanks, Grant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Number Format | Excel Worksheet Functions | |||
Moving custom number format to NUMBER | Setting up and Configuration of Excel | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) |