how do i remove % from a colum

[how to remouve %]

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

 

[kassie]

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

 

[Bernard Liengme]

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

 

[Gord Dibben]

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

 

[Bernard Liengme]

Yes one could do that but the topic was % formatting

 

[Gord Dibben]

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


Yes one could do that but the topic was % formatting

Gord Dibben MS Excel MVP

 

[Bernard Liengme]

You are correct - my apologies

 

[Gord Dibben]

From you Bernard, not necessary.

Just trying get it all straight in my mind, which is difficult sometimes<g>


Gord

You are correct - my apologies

Gord Dibben MS Excel MVP