Formatting Cell Problem

[Janie]

Hi,
I have a worksheet that I have formatted as Number with 0 decimals. One of the columns though displays 2 decimals and I can't seem to format it differently. I have tried highlighting even one cell and reformatting it individually to no avail. It is carrying 2 decimal places. I've also tried using format painter, but still doesn't work.

Anyone have any idea what is going on?

[63falcondude]

What is the result of =ISNUMBER(C2) (assuming that column C is the problematic column.

If it returns FALSE, the "number" is being seen as a text value.

There could be a couple of reasons for this.

Try highlighting the problematic column > Data > Text to Columns > Finish

Can you now adjust the number of decimal places?