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.