View Single Post
Old 09-01-2011, 19:16   #27
TheNorm
Inactive
 
TheNorm's Avatar
 
Join Date: Jun 2006
Location: Cambridge
Services: Sky TV, VM TV, 20meg bb, tel, and a lobster (but the lobster died).
Posts: 4,349
TheNorm has a nice shiny star
TheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny star
Re: Excel - working out net and vat ???

Quote:
Originally Posted by haydnwalker View Post
Right click on the cells you want to round to the nearest penny and choose "format cells" and click on the number tab and change the decimal places to 2 that should be it - no calculations necessary.

OR do the same right click etc and set the number format to currency
Are you sure those methods round up?
TheNorm is offline   Reply With Quote