98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » learn excel - Changing figures to negatives
learn excel - Changing figures to negatives
Resolved · Low Priority · Version Standard
Tue 29 May 2007, 09:44Delegate Nathan said...
Nathan has attended:
Excel Advanced course
Changing figures to negatives
How do I turn a column of postive figures into negatives?
Tue 29 May 2007, 10:37Trainer Tracy said...
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
Tue 29 May 2007, 11:22Delegate Nathan said...
RE: Changing figures to negatives
Hooray! thank you
But can I then further edit my new negative figures with decimal places and Currency?
Tue 29 May 2007, 12:28
Edited on Tue 29 May 2007, 12:55Trainer Tracy said...
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
-
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move or Highlight CellsUse any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move. |
