Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training courses - negative figures

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Negative figures

excel training courses - Negative figures

ResolvedVersion Standard

Claire has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Negative figures

Can I have negative figures showing in brackets, ie (1,543) instead of a subtraction, ie -1,543? If so, how do I do it please?

RE: Negative figures

Hi Claire

I had a bit of a look into this using Excel Help, and surprisingly, it's quite useful!

If you look up create custom number formats in Excel Help, then click on the Create or delete a custom number format link then you will find information on this. I think it would be easier for you to look up Help rather than me trying to explain it as it provides quite a logical explanation with a picture as well.

I hope you enjoy the intermediate and advanced Excel courses.

Kind regards
Amanda

Excel tip:

Removing custom dictionary entries

If you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.