Sorry for the basic question but I have a string that reads 275932.49 and when I change it from a string to a number it reads 275. No matter what number setting I put it on whenever I move it from a string to a number in order to Sum it, it loses characters. Can someone help me understand a work around for this?
Solved! Go to Solution.
Hi @McD_Ford
It's happening because of the comma in the string. You could use a formula like: Replace([Gross Pay],',','') to remove it prior to converting.
Thanks that worked for me. I appreciate it.