Cell Formatting

Posted by Steve on August 10, 2001 7:47 AM

I have imported a .rtf file from Word 97 into Excel 97 and I am having problems with the currency format. The original file had some negative numbers formatted like: #,###- (negative sign at the end). The current cells are set to currency with the negative sign in front. Is there any way to get the negative sign in the back to move to the front without having to do it manually for a 10,000 row sheet. The positive numbers are fine. Thanks for your help!

Posted by Cory on August 10, 2001 7:57 AM

Try selecting these cells you're talking about then right-click on them. Select 'Format Cells', then on the 'number' tab select 'Custom'. Use the following format and your negative numbers should be red and in the format you described:

$#,##0.00_);[Red]($#,##0.00"-")

Did that work?

Cory

Posted by Steve on August 10, 2001 8:07 AM

I gave it a try and it worked great.
Thanks for your help, Cory.

Steve