If you can live with "1990.", you could use a number format of:

0000.###

It'll show:

1990.
1900.1
1900.23
1900.345

depending on the number of decimal places used.

If you absolutely can't have a decimal point for the whole number, you can do it
manually or run a macro:

If those values don't change (since they're headers), I gotta believe selecting
all those cells and changing them once would be the easiest way.



Sam wrote:

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!

--

Dave Peterson