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?
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
-