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

B

burtsbees

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

Ron Coderre

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
 
Top