Spreadsheets roundup

emma1990emma1990 Feels At HomePosts: 34Registered
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 Posts: 820Registered
    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 Posts: 794Registered
    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 Posts: 34Registered
    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.