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=4941 |
+-------------------------------------------------------------------+

--
asim
------------------------------------------------------------------------
asim's Profile: http://www.excelforum.com/member.php...o&userid=35530
View this thread: http://www.excelforum.com/showthread...hreadid=555694