Home For AAT student members AQ 2013 AAT Level 3 (Level 6 in Scotland)
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Spreadsheets roundup

emma1990emma1990 Feels At HomeRegistered Posts: 34
May seem a bit of a stupid question but can anyone tell me how you would "change the format of all numerical cells to currency rounded to the nearest £"?

Comments

  • RobClarkeRobClarke Experienced Mentor Registered Posts: 820
    You need to do the =round function

    I think from memory to round to nearest £ you would =ROUND(A1,0) - where A1 is the cell where you have entered the amount to be rounded?
  • coojeecoojee Experienced Mentor Registered Posts: 794
    emma1990 wrote: »
    May seem a bit of a stupid question but can anyone tell me how you would "change the format of all numerical cells to currency rounded to the nearest £"?

    You highlight the cells you want to alter then go to format cells, choose currency and you can then set the rounding there, to 2 dp or more, 1 dp or 0 dp which will give you to the nearest £
  • emma1990emma1990 Feels At Home Registered Posts: 34
    Oh amazing thank you!!

    for some reason was thinking it meant round all of them up and couldn't see a way of doing it except individually!
Sign In or Register to comment.