Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The button on the toolbar only changes the formatting, if you look in tyhe
formula bar you will see that the number is still the same. Instead of just calculating the grade, Round it as in: =ROUND(Your formula,0) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Anna H Patrick" <Anna H wrote in message ... Am working on a school grading worksheet to merge into a letter to each child's parent(s). I want to round the grades to a whole number and not to a decimal number. I used the tool on the toolbar to get rid of decimal but it comes back when I use the merge mail feature. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Average and Round together | Excel Worksheet Functions | |||
Round number to the thousands without changing underlying number | Excel Discussion (Misc queries) | |||
I need help finding an average | Excel Discussion (Misc queries) | |||
Excel. How to round a number to nearest half number? | Excel Discussion (Misc queries) | |||
Finding the most/least/average occurrence(appear) number? | Excel Discussion (Misc queries) |