"CR" value format

[Guest]

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]

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]

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?

 

[Guest]

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