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 |
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 |
All times are GMT +1. The time now is 10:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com