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

learn excel - changing figures negatives

Forum home » Delegate support and help forum » Microsoft Excel Training and help » learn excel - Changing figures to negatives

learn excel - Changing figures to negatives

ResolvedVersion Standard

Nathan has attended:
Excel Advanced course

Changing figures to negatives

How do I turn a column of postive figures into negatives?

RE: Changing figures to negatives

Hi Nathan,

Thank you for your question.

To format positive cells into negative ones, simply highlight the cells you want to change. Go to Format>Cells and down to Custom. Where it says General highlight it and overtype and put -#### and that should change your positives to negatives.

Hope that helps

Tracy

RE: Changing figures to negatives

Hooray! thank you

But can I then further edit my new negative figures with decimal places and Currency?

Edited on Tue 29 May 2007, 12:55

RE: Changing figures to negatives

Thank you Nathan,

I am gald I can answer your question!

Yes, you can edit you new negative figures by using the code

-

RE: Changing figures to negatives

Brilliant, thank you

Nx

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

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.09 secs.