Hi all,
I am trying to format a number field so it can be exported to a text file
for import.  I need to format numbers and remove the decimal (if it has
one), zero fill to the left (field is 15 characters) and include a positive
or negative sign on the far right.  The 15th character is the +/- sign.

Examples:
1234.00        should be     00000000123400+
10.25            should be     00000000001025+
12                 should be     00000000001200+
-845.27         should be    00000000084527-

I seem to have the formatting correct except for the +/- sign
I use:    =TEXT(100*F3,"000000000000000")     to get the numbers formatted
The problem is the +/- sign.
I thought about using an adjacent field with:    =IF(F3 > 0,"+","-")
which give me the +/- sign next to the number, which is usable.
My problem with this is with negative numbers (like -845.27).  The field
that contains the re-formatted number (using the =TEXT command above) still
include the negative sign.  So when the 2 cells are put together I get:
00000000-84527-

Any ideas?

Thanks in advance.