LinkBack URL
About LinkBacks
Hi, I have a sheet in which I have done somehting which is changing numbers in italics to Credit and rest as debit?
Hi, I have a sheet in which I have done somehting which is changing numbers in italics to Credit and rest as debit?
It seems you custom formatted the Debit cells as: ""0.00" Dr" and the Credit cells as ""0.00" Cr"
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
How do I fix this?
Originally Posted by NBVC
How do i identify the formula usd here?
Thanks I feel stupid
See i understand that we have that format here but if I have to change it to a format where it will show me that the one in CR is (-) and one in + is a debit. the situation is I cant sort it or filter it as debits and credits with the current format. How do I change them into a format where I can work on the file
They are not formula, they are formats.
Right click any cell and select Format Cells and then go to the Number tab.. you will see the chosen format is custom and the type is as mentioned above.
No need to feel stupid... sometimes it's the simple things can drive you mad... I've had those situations too...
As it stands you cannot sort by credit/debit.
What you will need to do is go to all the ones that are supposed to be Debits and enter a - in front of the number.
Then select the whole range and go to Format Cells and custom format as:
0.00 " Cr";0.00 " Dr"
then you will be able to sort...
I have a thousand line items how do I do it manually? Any ideas or shortcuts?
I think someone will have to come up with a VBA macro to do it for you (I am not a VBA expert).. as I don't think there is a way in native Excel to determine which of the 2 formats you have and to change the CR to -ve.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks