Excel – How to add zeros to the right of a decimal

microsoft excel

I'm trying to add trailing zeroes to the right of a decimal number in Excel. I have cells with these values:

6.13
31.41592
2.124

How can I make them all have 6 decimal positions like this?

6.130000
31.415920
2.124000

EDIT: After adding the trailing zeros, I need to use the resulting values inside another formula. That is why the Format Cells dialog won't work.

Thanks!

Best Answer

If you are trying to concatenate the value with something else (based on your comment above), you can use the TEXT function to specify a number format for the decimal in your formula. For example, if you have a decimal 3.25 in A1 and grams in B1, you can specify 6 decimal places with the following:

=TEXT(A1,"#.000000")&" "&B1

This should result in 3.250000 grams.

Related Question