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!