This question already has an answer here:
The cell should show 1M (1 month) and have the value of 30 (days) for computation. What is the best way to do so?
I typed in the cell 1M and then went to
Home-> Conditional Formating-> New rule-> Format only cells that contain -> Format only cells with SPECIFIC TEXT containing =A2=30. Then I clicked on FORMAT-> Number-> Custom-> General-> OK-> OK
...but it doesn't change anything.
Could you please help?