98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Rounding
Rounding
Resolved · Low Priority · Version 2003
Claire has attended:
Excel Advanced course
Rounding
How do you round for eg 34,000 to 34 using a formular?
RE: rounding
Hi Claire
The ROUND function does not remove the zeros (0) so 34,249 for example can only be rounded to 34,000.
What you are asking is for the number to lose a certain number of zeros, in this case 3
THis means you need to create a formula that takes the number in a cell (eg D3 and divide it by 1,000) as seen below
[b]
Amount
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Apply Autosum with keyboard shortcutIf you press Alt and = at the same time, it applies autosum. |