Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting the number of decimal places for a text box. | Excel Discussion (Misc queries) | |||
how to count the number of decimal places in a cell? | Excel Worksheet Functions | |||
Converting a number to 2 decimal places | Excel Discussion (Misc queries) | |||
How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) | |||
Number Format Issues-Decimal Places | Excel Worksheet Functions |