Adding Suffix in excel- imp for Rs - #"rs"

Resolved Question

Show me another»

How in Excel can you add a suffix such as mm (millimeter) to a number and still have it treated as a number?

every time I right click on a cell and pick format cell I go to custom and type it in and it says that it can't do that. I want to do inches " as well

BEST ANSWER

In the custom box put
#"mm"

This is a cheat for inches. Put
#"''"
(hash followed by double quotes followed by two single quotes followed by double quotes)