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.
If you are trying to concatenate the value with something else (based on your comment above), you can use the
TEXTfunction to specify a number format for the decimal in your formula. For example, if you have a decimal
B1, you can specify 6 decimal places with the following:
This should result in