Convert to decimal

[Elmarie_Kies]

Hello, 
I have a problem with converting a field to decimal. There are instances where it has one decimal and other two decimals. I tried to replace the 0.0 with 0.00 and then check for the 3 last characters where the first character is not a fullstop and then pad a zero on but it did not work. Any ideas to do this in a efficient manner?

[Idrissshatila]

Hello @Elmarie_Kies ,

try changing the column type to decimal.

[Elmarie_Kies · Accepted solution]

I have done that first yes, but then it gives an error. I have however resolved the issue by replacing the fullstop (".") with a comma (",") and then convert it to decimal. Thank you.