% (Percent) formatting automatically changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard LT - 30 Oct 2007 19:06 GMT

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.

Reply to this Message

Brian Withun - 31 Oct 2007 18:03 GMT

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

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

Reply to this Message

Rate this thread: