May 01 2018
03:36 PM
- last edited on
Jul 25 2018
11:54 AM
by
TechCommunityAP
May 01 2018
03:36 PM
- last edited on
Jul 25 2018
11:54 AM
by
TechCommunityAP
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 which is next to numbers and make excel get just number and make the calculation ?
May 01 2018 04:10 PM
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?