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?

Number.PNG

string.PNG

Luke_C

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.