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 decimal3.25
inA1
andgrams
inB1
, you can specify 6 decimal places with the following:This should result in
3.250000 grams
.