On Mon, 30 Jan 2006 08:41:49 -0800, "Mary"
wrote:

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



Assuming your first example has a typo, then:

=TEXT(SUBSTITUTE(A10,".",""),REPT("0",13)&";"&REPT ("0",13))

(returns 0007473776069 and not
0000747376069)



--ron