Forum Discussion
Conditional Formatting for decimals
Hello Experts, I am creating an excel sheet where user will have to put values with 4 decimal places. The value will turn red if it does not have four decimal places (i.e. more or less decimal pl...
If you enter 1.2340, Excel stores the value 1.234 even though it is displayed as 1.2340. So it does not "know" you intended 4 decimal places.
Similarly, if you enter 1.0000, Excel will store 1 and not 1.0000.
A workaround would be to format the cells as text, or to prefix each value that you enter with an apostrophe '. Excel will then store the value as entered.
You can use the VALUE function to convert the text values to numbers (and some functions will automatically treat the values as numbers).
Thanks HansVogelaar for the explanation!
I too believe its hard to get the desired output.
I too believe its hard to get the desired output.