This may be a really dumb question, but hey here goes.
I have a column of positive monetary amounts (i.e. debits). They SHOULD be
negative amounts (i.e. credits).
Is there a way to change all of them from positives to negatives in one go?
Thanks
This may be a really dumb question, but hey here goes.
I have a column of positive monetary amounts (i.e. debits). They SHOULD be
negative amounts (i.e. credits).
Is there a way to change all of them from positives to negatives in one go?
Thanks
Hi
Type -1 in a blank unused cell. Copy this, select your range and then
Edit|Paste Special|Multiply.
Take a copy of your sheet before you start!
--
Andy.
"Matthew Hackett via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
> This may be a really dumb question, but hey here goes.
>
> I have a column of positive monetary amounts (i.e. debits). They SHOULD be
> negative amounts (i.e. credits).
>
> Is there a way to change all of them from positives to negatives in one
> go?
>
> Thanks
Worked a treat - thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks