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

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