Spreadsheets roundup
emma1990
Registered Posts: 34 Epic contributor 🐘
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 £"?
0
Comments
-
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?0 -
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 £0 -
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!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 325 NEW! Qualifications 2022
- 160 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 274 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 202 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership