i wanted a percntage in one box of a colum but now every box in that colum
comes as a percentage how do i stop this i havetried hitting the % button
again but to no avail please help its recking my head

You probable select the column before applying this format. To resolve,
select the cells you do not want formatted as %, right click, select format
cells, and format it as General, or as Number, or as whatever you want it to
be

"how to remouve %" wrote:

i wanted a percntage in one box of a colum but now every box in that colum
comes as a percentage how do i stop this i havetried hitting the % button
again but to no avail please help its recking my head

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"how to remouve %" <how to remouve wrote in
message ...
i wanted a percntage in one box of a colum but now every box in that colum
comes as a percentage how do i stop this i havetried hitting the % button
again but to no avail please help its recking my head

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

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

The subject was % formatting, but the topic was stopping the % sign from showing
as OP moved down the column.

i wanted a percntage in one box of a colum but now every box in that colum
comes as a percentage how do i stop this i havetried hitting the % button
again but to no avail please help its recking my head

Gord

On Thu, 21 Sep 2006 15:51:30 -0300, "Bernard Liengme"
wrote:

Yes one could do that but the topic was % formatting

Gord Dibben MS Excel MVP

You are correct - my apologies
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
The subject was % formatting, but the topic was stopping the % sign from
showing
as OP moved down the column.

i wanted a percntage in one box of a colum but now every box in that
colum
comes as a percentage how do i stop this i havetried hitting the % button
again but to no avail please help its recking my head

Gord

On Thu, 21 Sep 2006 15:51:30 -0300, "Bernard Liengme"
wrote:

Yes one could do that but the topic was % formatting

Gord Dibben MS Excel MVP