Hi ,
Just like Excel, If I use the format "#,##0_);(#,##0)" in a cell, negative numbers should be displayed in parenthesis without the negative sign.positive numbers should be displayed with a blank on the right side of the number in the cell. But now negative numbers displayed correctly,positive numbers displayed wrong. Like "-23" displayed"(23)", "23" should displayed "23 " not "23_)". If anyone can help me?
thanks,
Mark Li