Forum Discussion
I would like to use formula by ignoring letters attached to numbers in cells.
I would like to use divide formula between cells but my numbers in my cells has like $ sign or ''Ct.'' letters next to numbers. what should i write into formula to get rid of the letters or signs whi...
It depends. If you have cells with applied currency format, you shall do nothing, values are numbers. Did you try to do any ariphmetic with your cells?