% (Percent) formatting automatically changes

  • Thread starter Thread starter Richard LT
  • Start date Start date
R

Richard LT

This seems like a MS bug. If not, does anyone know how to fix this?

I have seen this bug twice now in different workbooks (xls), I first saw
this bug in a xls where cells automatically changed formatting from % to
General when # was replaced with = sign in formulas. All formulas in our xls
templates have # instead of = signs so we can copy their contents to other
xls w/o creating a references to the xls template.

Here's how I worked around this issue:
Ex:
C77(problem cell) is
=C74/PRC1_Value

So we change C74 (numerator) from "=C67-C72" to "=DOLLAR(C67-C72,0)" and
clear C74's formatting.

I found that clearing the formatting & using DOLLAR() in the numerator cell
(to apply it's currency format) fixes the issue.
 
This seems like a MS bug. If not, does anyone know how to fix this?

I have seen this bug twice now in different workbooks (xls), I first saw
this bug in a xls where cells automatically changed formatting from % to
General when # was replaced with = sign in formulas. All formulas in our xls
templates have # instead of = signs so we can copy their contents to other
xls w/o creating a references to the xls template.

Here's how I worked around this issue:
Ex:
C77(problem cell) is
=C74/PRC1_Value

So we change C74 (numerator) from "=C67-C72" to "=DOLLAR(C67-C72,0)" and
clear C74's formatting.

I found that clearing the formatting & using DOLLAR() in the numerator cell
(to apply it's currency format) fixes the issue.
Click to expand...

I'm not entirely sure I understand what you're saying, but I have
noticed that if you put a formula into a cell which has General
formatting, the cell will take on the format of the cells in its
formula.

When I assign G1 the formula =P1/D1, (where G1 has general formatting,
P1 has percentage formatting, and D1 has date formatting), the cell G1
takes on a date format.

Could this be what you're seeing?

Brian Herbert Withun
 
Back
Top