Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
quick question about spreadsheets, I'm missing a couple of things
apprentice_tycoon
Posts: 3,300 Forumite
in Techie Stuff
It's my self assesment tax spreadsheet that I'm filling in on Microsoft Works.
It's the first time I've used Microsoft Works for this tedius job, there are 2 things that would make it easier and I don't know how to correct them.
The system I used to use used to fill in the rest of the word for me so I'd type in 'b' and it used to fill in 'bank'
The second niggle is I can't seem to adjust the 00's after the decimal point. I type in 200.00 and it shows it as 200 - can I alter this?
Any help would be appreciated.
It's the first time I've used Microsoft Works for this tedius job, there are 2 things that would make it easier and I don't know how to correct them.
The system I used to use used to fill in the rest of the word for me so I'd type in 'b' and it used to fill in 'bank'
The second niggle is I can't seem to adjust the 00's after the decimal point. I type in 200.00 and it shows it as 200 - can I alter this?
Any help would be appreciated.
0
Comments
-
Format Cells, Number for the .00 thingy. You will have to highlight the column first.
And you are on about autofill for the other thingy I dont know
if thats available in Works, do a Excel help for autofill maybe0 -
As intel says, for the decimal points go to Format>cells>number>number and scroll to 2, or Format>cells>number>currency if you want a "£" sign and two decimals.
For the autofill go to Tools>Options>Edit and tick the box for "Enable AutoComplete for cell values"0 -
Thank you both - I've got the decimal point thing sorted so that's great but the autofill thing has defeated me. I looked at the tools>options>edit thing but it didn't have the autocomplete option, it must be on a different system to mine, I just learned how to drag the word 'bank' down all the columns so that's a bit less work but there is still cheque and paypal etc to type out!0
-
It probably isn't on Works' spreadsheet tool because it is a cut-down version of Excel with limited features. I guess you were using Excel before as Excel has the AutoFill feature.apprentice_tycoon wrote:Thank you both - I've got the decimal point thing sorted so that's great but the autofill thing has defeated me. I looked at the tools>options>edit thing but it didn't have the autocomplete option, it must be on a different system to mine, I just learned how to drag the word 'bank' down all the columns so that's a bit less work but there is still cheque and paypal etc to type out!
Can you use abbreviations - e.g. P for paypal, Chq for Cheque etc. then put a key at the top?still cheque and paypal etc to type out!0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.5K Work, Benefits & Business
- 606.2K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards