how to give all numbers the same digit zeros on a sheet

[abdi1]

hi
if i have a set of numbers on a row, the first in A1 is the base value lets say it's 0.0381 the others is differ from the base value in that it's digits are not the same after the comma (517 --- 719-----21.95833---4.2797-----0.08185337)
how to make those numbers the same as the base value (0.0381) in term of digits value? like this
0.0517
0.0719
0.0219583
0.042747
0.08185337

[PeteABC123]

Hi abdi1:

Is the base value always x.xxxx (4 decimal points?), or does the base value change depending on the values displayed in A1?

Creating a custom format of 0.0000 will get your 4 decimals lined up.. ., but will that change; dependent what's shown in A1?



Pete

[FDibbins]

I have this working for the 1st bunch, just not figured out the value(s) that already contain the .0xxxx....
=B1/10^(LEN(INT(B1))+IF(B1<1,0,1))

[abdi1]

Hi abdi1:

Is the base value always x.xxxx (4 decimal points?), or does the base value change depending on the values displayed in A1?

Creating a custom format of 0.0000 will get your 4 decimals lined up.. ., but will that change; dependent what's shown in A1?



Pete

peteABC123...the base value change ...as will as all numbers in the row...so that the custom format will not solve the problem......thanks for you

[abdi1]

=B1/10^(LEN(INT(B1))+IF(B1<1,0,1))

thanks for you FDibbins...this forula works ..but what if the values in the row changed
??.. if i have 0.00381 or 0.000381 rather than 0.0381 .. also the values from B1 to H1 are not fixed...

[kvsrinivasamurthy]

In A2 then copied across

=VALUE("0.0"&VALUE(SUBSTITUTE(A1,".","")))

[abdi1]

=VALUE("0.0"&VALUE(SUBSTITUTE(A1,".","")))

kvsrinivasamurthy....thanks for you.....this formula is brilliant ....problem solved