View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tonso Tonso is offline
external usenet poster
 
Posts: 90
Default 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