Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I format charge card numbers? | Excel Discussion (Misc queries) | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
Converting numbers to date format from csv files | Excel Discussion (Misc queries) |