Yes one could do that but the topic was % formatting
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I would uncheck the "entend data range formats and formulas"

"Enable automatic percent entry" just changes the percentage formatting.

Enable automatic percent entry........from help

Select to multiply by 100 all numbers less than 1 that you enter in cells
formatted in the Percentage format. Clear this check box to multiply by
100 all
numbers that you enter in cells formatted in the Percentage format,
including
numbers equal to or greater than 1.


Gord Dibben MS Excel MVP


On Thu, 21 Sep 2006 15:00:49 -0300, "Bernard Liengme"
wrote:

When you type, for example, 5%, 6%, and 7% in three cells (say A1:A3),
Excel
very kindly formats the rest column A as percent. So when you type 8 in A4
Excel makes it 8%. As Ang recommends, formatting the rest of the cells as
General BEFORE you add new data will do the trick.
If you do not like this behaviour, use Tools | Options and on the Edit tab
unselect 'Enable automatic percent entry'.
best wishes