📨 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!

Excel 2002

2»

Comments

  • Sagz_2
    Sagz_2 Posts: 6,251
    Part of the Furniture 1,000 Posts Combo Breaker
    Forumite
    You should have a currency button on the toolbar (looks like a note with a pile of coins in front of it) - it will but the £ and decimal point in for you
    Some days you're the dog..... most days you're the tree! :D
  • aardvaak
    aardvaak Posts: 5,836
    Part of the Furniture 1,000 Posts Name Dropper
    Forumite
    You should have a currency button on the toolbar (looks like a note with a pile of coins in front of it) - it will but the £ and decimal point in for you

    No I hav'nt got it on the toolbar - how fo I get it there?
  • Sagz_2
    Sagz_2 Posts: 6,251
    Part of the Furniture 1,000 Posts Combo Breaker
    Forumite
    right click on the cell, select 'format cells' from the list and then select currency from there
    Some days you're the dog..... most days you're the tree! :D
  • aardvaak
    aardvaak Posts: 5,836
    Part of the Furniture 1,000 Posts Name Dropper
    Forumite
    right click on the cell, select 'format cells' from the list and then select currency from there

    Is there no way of getting perm. on the toolbar?
  • Sagz_2
    Sagz_2 Posts: 6,251
    Part of the Furniture 1,000 Posts Combo Breaker
    Forumite
    View: Toolbars: Formatting
    Some days you're the dog..... most days you're the tree! :D
  • aardvaak
    aardvaak Posts: 5,836
    Part of the Furniture 1,000 Posts Name Dropper
    Forumite
    Thank you for all your help.
  • littlepanther
    littlepanther Posts: 155 Forumite
    This is a really good, and short, video tutorial on how to use AutoSum and with some useful tricks. Go to the Excel section of the Jargon Free Help website. I've been using these on my training courses. There is also Mr Excel but he is quite advance. Just google these two sites.
    Hi, we’ve had to remove your signature. If you’re not sure why please read the forum rules or email the forum team if you’re still unsure - MSE ForumTeam
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 355.9K Banking & Borrowing
  • 255K Reduce Debt & Boost Income
  • 456.2K Spending & Discounts
  • 248.4K Work, Benefits & Business
  • 606.1K Mortgages, Homes & Bills
  • 179K Life & Family
  • 263.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.