import text file-currency not working

[motrust]

hello,
i am importing a text file that shows inventory adjustments. Therefore, the
Adjusted dollar amount is viewed with a + or - before each amount. The
negative amount shows on my table , but the +amount doesn't. How can I get
both the + and - to show in the table?

 

[hmadyson]

I am assuming that this is a fixed length text file. I would suggest having a
1 character length field that stores the +/- and then the next field is a
number that has the full amount. This way you can use the 2 fields to
determine if this is a plus or minus field.

Please let me know if I can provide more assistance.

 

[John Nurick]

Assuming that these values are being imported into numeric fields, you
probably just need to apply an appropriate format to the field (to
display the values in table datasheet view) or control (on a form or
report).

Something like this in the Format property should do:
+#,##0.00;-#,##0.00;0

 

[motrust]

That works, but now it is rounding to the whole dollar

 

[John Nurick]

The format string I posted displays two decimal places ...

.... except for zero: to display zero as 0.00 use
+#,##0.00;-#,##0.00;0.00

Or are you importing these values into the wrong field type? Number
(Long) and Number (Integer) only take integers: for currency values it's
usually best to use the Currency field type, or else Double.