how do i remove % from a colum

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

Guest

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
 
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
 
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
 
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
Click to expand...

Gord Dibben MS Excel MVP
 
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
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top