Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Simple question (i hope)
Is there a simple way i can round numbers to the nearest thousand by using the format cells command. For example i would like to display 1,234.56 as 12 I don't want to be diving by 1000 and rounding to zero decimal places because i still want the whole number displayed in the formula bar when selecting it. i use excel 2003 thanx Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
Rounding Numbers | Excel Worksheet Functions | |||
Rounding a number down to the nearest 5? | Excel Worksheet Functions | |||
WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? | Excel Worksheet Functions | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |