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.
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.