Rounding to 3 decimal points

[carterfleming]

I have a column of whole numbers that I want to a.) convert to decimals and b.) have 4 decimal points showing (i.e., 1.2345).

So basically, dividing a column by 100 and get it to show to 4 decimal places.

I've tried the round function in a Formula but it's not working how I want it to.

[carterfleming]

Also the column to be converted does contain zeroes, not sure if that factors in but thought worth mentioning.

[MilindG · Accepted solution]

Is this somewhat you're looking to do?

[apathetichell]

Are you using something like round([field1]/100,.0001)? What is your output vs the output you want?

[carterfleming]

Perfect, that worked! Thank you.