| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Standardise all cells at once
Hello, I would welcome some help with the following: I would like the user to be able to perform the functions below, to all the numbers in a range a cells i.e. B3 to E13 (this will not change) by simply selecting an option or pressing a predefined button(s). - Change all values to % - Change all values to Number - Change all values to Currency Within each of these options they should be able to: - Increase decimal place - Decrease decimal place I have attached a spreadsheet which this will be used on. Can you help with a simple command/function or macro? Regards Asim +-------------------------------------------------------------------+ |Filename: SLA_Forecast Tool.zip | |Download: http://www.excelforum.com/attachment.php?postid=4942 | +-------------------------------------------------------------------+ -- asim ------------------------------------------------------------------------ asim's Profile: http://www.excelforum.com/member.php...o&userid=35530 View this thread: http://www.excelforum.com/showthread...hreadid=555701 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Standardise all cells at once
Him asim,
Most of what you ask for is already built in Customize toolbars Commands Categories Format Drag the following icons onto your toolbar(s) Percent style Currency Increase decimal Decrease decimal You could put these onto your own custom toolbar, select the Toolbars tab and New... Regards, Peter T "asim" wrote in message ... Hello, I would welcome some help with the following: I would like the user to be able to perform the functions below, to all the numbers in a range a cells i.e. B3 to E13 (this will not change) by simply selecting an option or pressing a predefined button(s). - Change all values to % - Change all values to Number - Change all values to Currency Within each of these options they should be able to: - Increase decimal place - Decrease decimal place I have attached a spreadsheet which this will be used on. Can you help with a simple command/function or macro? Regards Asim +-------------------------------------------------------------------+ |Filename: SLA_Forecast Tool.zip | |Download: http://www.excelforum.com/attachment.php?postid=4942 | +-------------------------------------------------------------------+ -- asim ------------------------------------------------------------------------ asim's Profile: http://www.excelforum.com/member.php...o&userid=35530 View this thread: http://www.excelforum.com/showthread...hreadid=555701 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| IF forumla to standardise text | Excel Discussion (Misc queries) | |||
| Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
| Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells | Excel Programming | |||
![asim[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
