decimal places

[Arkouda]

Hi all - I thought  that woudl be simple but i have spent some time looking for an answer 

I have the folowing data that comes in 

.2

1.2

50.22234555

75

but want the decimal to be fixed 

.002

.12

.52223455

.75

I have tried Regx and a formula but can't seem to get the result needed 

Thank yo 

[Qiu]

@Arkouda 

I am sorry but I have failed to see a patern here.

.2 --> 0.002

1.2 --> 0.12

What makes the above having difference?

[Arkouda]

Hi Qui

I need to show all values leading by a decimal 

Current data comes in as mixed 

.2

1.2

50.22234555

75

.12

but need the the values to be lead by a decimal like below

.002

.12

.52223455

.75

[Qiu]

@Arkouda 
So your data coming in a mixed format.

you want them all to be converted to be in a format that is leading by a decimal point?

so still what is the difference below

.2 --> 0.002 

1.2 --> 0.12
Can you give us the logic here, explaining how that each numer gets converted.

[Arkouda]

Correct want all values to lead by a decimal but needs to be six places following the decimal

See below as current data comes through (input > desired)

Bonus %
Input Data	Desired Output Data
90	.090000
90	.090000
90	.090000
9.90390733904294	.090390
9.52380952380952	.095238
9.52380952380952	.095238
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.47885986756895	.094788

[chukleswk · Accepted solution]

You can use the formula tool and create a new field with a fixed decimal of 8.6 and divide the “Bonus %” by 100. That should give you the results that you want.

[Qiu]

@Arkouda 
Now it is very clear.

As suggested by @chukleswk , Lets use the format of Fixed Decimal.