DashboardNovice
Member
Hi,
In the attached file, in the yellow cells I am trying to apply custom number formatting. Here is what I am attempting to do.
1. If a whole number is entered, display it as is without a decimal point. For example, if 392 is entered, display 392 and not 392.00
2. If a decimal is entered, then display the decimal point and the digits to the right of the decimal. For example, if 7.5 is entered, display it as 7.5
Basically I'm trying to display the value as entered.
The problem I'm running into is being able to display a decimal point only when entered. Is this even possible?
In the attached file, in the yellow cells I am trying to apply custom number formatting. Here is what I am attempting to do.
1. If a whole number is entered, display it as is without a decimal point. For example, if 392 is entered, display 392 and not 392.00
2. If a decimal is entered, then display the decimal point and the digits to the right of the decimal. For example, if 7.5 is entered, display it as 7.5
Basically I'm trying to display the value as entered.
The problem I'm running into is being able to display a decimal point only when entered. Is this even possible?