Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

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!

Re: Cell Formatting

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

Re: Cell Formatting

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.