Excel 2002 "auto" number format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excell 2002 when I create a formula in a cell, referring to another cell
Example: cell A1 = '=A2', then the number format of Cell A1 become equal
to number format of cell A2.
If cell A2 has a percentage number format "0.00%", then cell A1 that had the General number format, will have this percentage number format

Is it possible to turn this autofeature off
In Excel 2000, this doesn't happen

Best Regards
Candido Rodrigue
<[email protected]>
 
Hi Candido!

First, I don't think that you can control Excel's intellisence formatting
except by pre-formatting the cell to a format other than General.

Second, I don't think that Excel 2002 is different from Excel 2000 in this
respect.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Candido said:
In Excell 2002 when I create a formula in a cell, referring to another cell,
Example: cell A1 = '=A2', then the number format of Cell A1 become equal
to number format of cell A2.
If cell A2 has a percentage number format "0.00%", then cell A1 that had
Click to expand...
the General number format, will have this percentage number format.
 
Back
Top