Automaticallychanging the number of decimal places displayed
 

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

Automaticallychanging the number of decimal places displayed
 

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

"Tonso" wrote in message
ups.com...
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

Automaticallychanging the number of decimal places displayed
 

On Feb 15, 5:07 pm, "David Biddulph" wrote:
=ROUND(AA21,B$1)
--
David Biddulph

"Tonso" wrote in message

ups.com...



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- Hide quoted text -

- 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

Automaticallychanging the number of decimal places displayed
 

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.

--
Regards,
Fred


"Tonso" wrote in message
ups.com...
On Feb 15, 5:07 pm, "David Biddulph" wrote:
=ROUND(AA21,B$1)
--
David Biddulph

"Tonso" wrote in message

ups.com...



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- Hide quoted text -

- 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

Automaticallychanging the number of decimal places displayed
 

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 !
---------------------------------------------------------------------------
"Tonso" wrote in message
ups.com...
On Feb 15, 5:07 pm, "David Biddulph" wrote:
=ROUND(AA21,B$1)
--
David Biddulph

"Tonso" wrote in message

ups.com...



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- Hide quoted text -

- 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

Automaticallychanging the number of decimal places displayed
 

On Feb 15, 8:58 pm, "Ragdyer" wrote:
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 !
---------------------------------------------------------------------------"Tonso" wrote in message

ups.com...



On Feb 15, 5:07 pm, "David Biddulph" wrote:
=ROUND(AA21,B$1)
--
David Biddulph

"Tonso" wrote in message

roups.com...

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- Hide quoted text -

- 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- Hide quoted text -

- Show quoted text -

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

Tonso