String to Number

[McD_Ford]

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?

[Luke_C · Accepted 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.

[McD_Ford]

Thanks that worked for me. I appreciate it.