If your numbers can be of various lengths you can do if statements, and the formula can get very long, I did it for up to 7 figures: (IF(LEN(CONCATENATE({Final Sales},""))=4,(LEFT(CONCATENATE({Final Sales},""),1) & "." & RIGHT(CONCATENATE({Final Sale...