Copying Decimal Values To Different Cells With Leading / Trailing Zeros?

I have 4 columns (and a couple of other text columns) that are formatted as decimal with 6 dicimal points.

I need to create a text file with lines that are 80 bytes each from the spreadsheet - no spaces inbetween each of the characters.

The issue I am having is trying to format the 4 decimal point columns to be fixed numbers and retain the leading or trailing zeros to do a concatenation with the other columns.

Just an example of some what some of the values look like on my spreadsheet:

.123456 | .123450 | .012345 | .012340

Essentially when I'm all said and done, I would like the row to look like "text123456123450012345012340text"

I tried to format 4 new columns as general and use a "=right(cell,6)" and that worked pretty well for the cells that have leading zeros, but for the cells that have trailing zeros, it doesn't seem to pick up the zero. I tried to use a "=mid(cell,2,6)" but that didn't work either.