Excel 2007 : Customize Suffix "CR" to be denote as negative (-)

**ramesh2785** · 11-29-2011, 06:40 AM

Hello Friends,
I have spreadsheet contining number which are custamized some number are positive i.de with suffix "DR" & some are negative i.e "CR" but problem is i am not able to seperate negative number & positive numbers as this numbers are custamize & volume is so large that i can not do it manually by just putting negative sign for number with suffix "CR"

Attached file for reference.

Looking forward for solution

Regards,
Ramesh

**arlu1201** · 11-29-2011, 07:53 AM

Use this code in a blank module of your file -

Please Login or Register  to view this content.

**ramesh2785** · 11-29-2011, 08:00 AM

Thanks for ur reply but how to use this code i mean where it is to be enter???

Originally Posted by arlu1201

Use this code in a blank module of your file -

Please Login or Register  to view this content.

**royUK** · 11-29-2011, 08:51 AM

Don't quote whole posts -- it's just clutter.

If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

**arlu1201** · 11-29-2011, 09:05 AM

Open your excel file, select Alt+F11. You will see a code window open on the right. On the left hand side, there will be Microsoft Excel Objects. Right click on it and insert -> module. Then copy the code i provided you into the module. Then go to excel and run the macro (View - Macros). Hope this helps.