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

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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