TextFileTrailingMinusNumbers Property
True for Microsoft Excel to treat numbers imported as text that begin with a "-" symbol as a negative symbol. False for Excel to treat numbers imported as text that begin with a "-" symbol as text. Read/write Boolean.
expression.TextFileTrailingMinusNumbers
expression Required. An expression that returns one of the objects in the Applies To list.
Example
In this example, Microsoft Excel determines the setting for cell A1, treating numbers imported as text that begin with a "-" symbol. This example assumes a QueryTable object exists on the active worksheet.
Sub CheckQueryTableSetting()
' Determine setting for TextFileTrailingMinusNumbers
If Range("A1").QueryTable.TextFileTrailingMinusNumbers = True Then
MsgBox "Numbers imported as text that begin with a '-' symbol " & _
"will be treated as a negative symbol."
Else
MsgBox "Numbers imported as text that begin with a '-' symbol " & _
"will not be treated as a negative symbol."
End If
End Sub