"CR" value format

Mar 15th, 2002, 05:46 AM

I have a document imported to Excel which has values in it. Unfortunately the credit values have CR after them. Is there an easy way to format them to a minus sign or brakets, PLEASE?

Dave Hawley · Mar 15th, 2002, 05:51 AM

Not sure I understood fully, but this should help

=SUBSTITUTE(A1,"CR","")*-1
OR
=SUBSTITUTE(A1,"CR","")*1
Both case sensitive

It will be a real number.

_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

[ This Message was edited by: Dave Hawley on 2002-03-15 04:53 ]

Aladin Akyurek · Mar 15th, 2002, 05:59 AM

Quote:

On 2002-03-15 04:46, Anonymous wrote:
I have a document imported to Excel which has values in it. Unfortunately the credit values have CR after them. Is there an easy way to format them to a minus sign or brakets, PLEASE?

Care to post a few examples along with expected results?

Mar 15th, 2002, 06:10 AM

Thanks Guys Works excellently using Substitute:

Output was this: 237.36CR
Result was this: -237.36

Which is just what I wanted to achieve.

Cheers again

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 05:46 AM	#1
Guest Posts: n/a	I have a document imported to Excel which has values in it. Unfortunately the credit values have CR after them. Is there an easy way to format them to a minus sign or brakets, PLEASE?

Mar 15th, 2002, 05:51 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Not sure I understood fully, but this should help =SUBSTITUTE(A1,"CR","")-1 OR =SUBSTITUTE(A1,"CR","")1 Both case sensitive It will be a real number. _________________ Kind Regards Dave Hawley OzGrid Business Applications Microsoft Excel/VBA Training [ This Message was edited by: Dave Hawley on 2002-03-15 04:53 ]

Mar 15th, 2002, 06:10 AM	#4
Guest Posts: n/a	Thanks Guys Works excellently using Substitute: Output was this: 237.36CR Result was this: -237.36 Which is just what I wanted to achieve. Cheers again