Data query and decimals places "Need 2 places"

[RBGDaboys]

I have a data query that pulls in some costing. It isn't always in the same format.
Example
12.87
12.4
150

I then use a function to make it 10 places:
=RIGHT("000000000000000000"&E5,10)
0000012.87
00000012.4
0000000150

The ploblem is a need the costing to ALWAYS have 2 deimal places even when my query returns 1 or 0 places. If less than 2 places I want to add zeros PLUS remove the decimal point.

Example
12.87
12.4
150

Would equal
0000001287
0000001240
0000015000

I then need to copy these numbers to a text file so plain cell formating doesn't work.

I search around here and found some help but no working solution.

Thank you for your time.

 

[big_mac]

have you tried =text(E5,"0000000000.00") this should make it text and 12 digits. adjust your 0's to how ever you need them.

 

[RBGDaboys]

That worked, thank you

BUT

I now need to remove that decimal point. I can with a macro but would be great to remove it in that fomular you gave me if it can be done.

 

[RBGDaboys]

Any ideas?

Thank you