Change a # w/decimal places to no decimals, 13 char's, w/leading 0
If you wanted to use a formula, you could try something like this.
=IF(LEN(SUBSTITUTE(SUBSTITUTE(A1,".",""),"-",""))<13,(REPT("0",13-LEN(SUBSTITUTE(SUBSTITUTE(A1,".",""),"-","")))&SUBSTITUTE(SUBSTITUTE(A1,".",""),"-","")))
This is with your original value in A1.
HTH,
Paul
"Mary" wrote in message
...
To import data into SAP from Excel, I need to create a load file that
converts a column w/positive or negative values & decimal places into all
positive values with no decimal places, and with leading zeroes--to fill
out
13 places. For example:
-74737.76069 needs to be converted to
0000747376069
and
105286.99 needs to be converted to
0000010528699
|