I want to add a plus sign behind a number and keep the leading zer

[Guest]

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.

 

[danioma]

try using a ' before the number
ex 0375
'037

 

[Guest]

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