LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting the number of decimal places for a text box. Aaron1978 Excel Discussion (Misc queries) 3 March 8th 06 04:59 PM
how to count the number of decimal places in a cell? Warren Smith Excel Worksheet Functions 7 August 28th 05 01:52 PM
Converting a number to 2 decimal places mattslav Excel Discussion (Misc queries) 2 June 4th 05 04:10 AM
How do I change the number of decimal places displayed in Excel Dan Excel Discussion (Misc queries) 1 February 23rd 05 10:31 PM
Number Format Issues-Decimal Places EXCELNCBOY Excel Worksheet Functions 1 November 4th 04 10:41 PM


All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"