TextFileTrailingMinusNumbers Property
TOC
Collapse the table of content
Expand the table of content

TextFileTrailingMinusNumbers Property [Excel 2003 VBA Language Reference]

Office 2003

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
		


Applies to | QueryTable Object


Show:
© 2016 Microsoft