I need to have a 15 digit number with a + or - sign at the end to export from
excel to a software package. When I add the + or - at the end of the number,
it deletes the leading zeros.

try using a ' before the number
ex 0375
'0375


--
danioma
------------------------------------------------------------------------
danioma's Profile: http://www.excelforum.com/member.php...o&userid=35112
View this thread: http://www.excelforum.com/showthread...hreadid=549653

Try this:


Select the range of cells to be impacted.

From the Excel main menu:
<format<cells<number tab
Category: Custom
Type: 000000000000000+;000000000000000-;000000000000000+
Click the OK button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"burtsbees" wrote:

I need to have a 15 digit number with a + or - sign at the end to export from
excel to a software package. When I add the + or - at the end of the number,
it deletes the leading zeros.