dont highlight the whole column. Try highlighting only those cells which
you want to change the format (not the cell having year value) and then
format


Sam wrote in message
...
Hello,

I have a table where each column heading is a year. The numbers in the
table display 5 places after the decimal point. When I select all and
format
the cells as a Number with only 3 decimal places, the years in the column
headings are also displayed with the three decimal places, like this:

1990.000 1991.000
13.478 13.902

How can I only format the numbers that already have places after the
decimal
point - i.e.
Before
1990 <- doesn't have decimal places
13.47895 <- has places after the decimal point

Thanks you!