Auto-percent formatting in Excel 2007

[RobBroekhuis]

This is driving me crazy. I have a workbook in Excel 2007 with a column where every time I make an entry, Excel decides to interpret it as a percent input. I enter 33.1, Excel puts 33.1% (0.331) in the cell. The cells in the column are all formatted "general", none of the adjacent cells have percent formatting (although there are a few columns further to the left that use percent). Any idea what may be causing this?

Rob

 

[SkipVought]

Hi,

Do you have ANY VBA code in your workbook?

Check int Excel Options -- ADVANCED: Editing Oprions, for Enable automatic percent entry.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[RobBroekhuis]

None whatsoever. Workbook saves as a .xlsx
Additional information: Right now I'm getting around the problem by copying a (manually fixed) cell with the general formatting down into all cells below. Excel only auto-formats with percent when the cell is empty.

Rob

 

[SkipVought]

are ALL the values in the column in question, NUMERIC VALUES?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[RobBroekhuis]

In the workbook as I described it, there were text values in the first three rows. To see if these mattered, I just created a new column to the left of the one that was giving me trouble. Nothing in any of the cells. All formatted as general. Filling in numbers in the cells from the top down gets me the percentage behavior. Very oddly, about mid-table (row 9), this behavior stops. It is all perfectly reproducible (I can undo, and repeat the whole sequence). I cannot tell any difference between the cells that are and those that are not affected. Before entering any values:

?range("r8").numberformat
General
?range("r9").numberformat
General

Of course after entering a value in R8 the numberformat changes to "0.00%"

Rob

 

[mscallisto]

Just a wild guess but have you tried "Detect and Repair"?

sam

 

[SkipVought]

Rob,

If you care to, send a comment to me thru one of my FAQs. I'll eMail you in return and you then, can send me your workbook to look at.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]