Forum home » Delegate support and help forum » Microsoft Excel Training and help » learn excel - Changing figures to negatives
|
|
|
The UK's most regular 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. |
learn excel - Changing figures to negatives
Resolved · Low Priority · Version Standard
Reply 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?
For upcoming training course dates see: Pricing & availability
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
Reply 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?
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
-
Reply Tue 29 May 2007, 13:52Delegate Nathan said...
RE: Changing figures to negatives
Brilliant, thank you
Nx
|