Standardise all cells at once

[asim]

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

[Peter T]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>