Forum Home
Press F1
Thread ID: 26472	2002-10-28 06:56:00	Now consider this (all Excel number formatters)	rugila (214)	Press F1

Post ID	Timestamp	Content	User
93825	2002-10-28 06:56:00	To display a number to the nearest (say) thousand without changing the number itself, try the custom format #,###,"000" This works (admittedly obtained by some trial and error) but does rather offend my sense of elegance. Isn't there a better way?	rugila (214)
93826	2002-10-28 07:58:00	Highlight the whole column by pressing the letter at the top of the screen... right click... select number... choose the number of decimal places... Is that what you were thinking of?? Lo.	Lohsing (219)
93827	2002-10-28 08:00:00	That should be right click, format cells, select number tab... click on number and adjust to the appropriate number of decimal places... is that what you wanted?? Otherwise you would probably need to use the "round" worksheet function... Lo.	Lohsing (219)
93828	2002-10-28 09:17:00	Sorry Lohsing but you're way way off beam. It's trivial to adjust AFTER the decimal point. Your suggestion would only work if Excel number format accepted negative decimal places. You may have a version of Excel that does this, but mine won't. Problem of displaying to nearest thousand (or million or billion) is solved as in my above post, but I still haven't figured out how to display to nearest 10, 100, 10,000, 100,000, ten million etc. (or even to nearest 5 or any other specified number, which I sometimes need to do). Any suggestions (that work) are welcome.	rugila (214)
93829	2002-10-29 07:05:00	You need to use an If then clause.	mikebartnz (21)
93830	2002-10-29 21:09:00	What do you mean by an If Then clause? This sounds like standard programming used to round numbers which is easy enough, but not obviously suitable to change formatting while leaving the underlying number unchanged. If you can do this (ie change number format without changing the underlying number in Excel) with IF - THEN I would sure appreciate the details.	rugila (214)
93831	2002-10-30 10:40:00	Create a formula in another cell and use If (value(cell) > 999) and (value(cell) < 1500) then do whatever. Sorry don't use Excell but from a programers view it should be something like that.	mikebartnz (21)
1