Automaticallychanging the number of decimal places displayed

[Tonso]

Using Excel 2002, I have created a form for others at work to use.
Depending on the circumstances, sometimes it is best to show the data
entered in AA21:AA200 with 5 decimal places, sometimes 3, sometimes 2,
or 1, or zero. Is there some way the user could enter the number of
decimal places desired in a cell or whatever so that the number of
decimal places displayed in these cells automatically change to
display that number of decimal places? Other cells in the sheet are
fixed at zero, or 1, 2, etc.

As always, thanks to all!

Tonso

 

[David Biddulph]

=ROUND(AA21,B$1)

 

[Tonso]

=ROUND(AA21,B$1)
--
David Biddulph








- Show quoted text -

I am so sorry, l but I do not understand. If I put that formula in a
cell, will it not be overwritten when the user enters a number into
that cell? The cells i am referring to are data entry cells. Tthe user
can of course just select all the cells and change the format to the
desired decimal places, but i was looking to automate that activity.
Thanks,

Tonso

 

[Fred Smith]

You asked "is there some way the user could enter the number of decimal places".

David answered.

What more do you want?

After the user enters the number of decimal places, store it in a place where
they won't override it. It doesn't have to be B1. Pick whatever cell you like,
and adjust the formula to suit.

 

[Ragdyer]

The default toolbar displays 2 icons for increasing and decreasing decimal
places.

Simply have your users select the cells to change, and click on the icons,
where each click will increase or decrease the decimals in the selected
cells by 1.

 

[Tonso]

The default toolbar displays 2 icons for increasing and decreasing decimal
places.

Simply have your users select the cells to change, and click on the icons,
where each click will increase or decrease the decimals in the selected
cells by 1.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !







- Show quoted text -

Thanks to all for the great responses! As usual, you have solved my
problem!

Tonso