P
patrick
Dear all
I am trying to link a tab-delimited *.txt file into access.
The data contains amounts such as
-1,560.87
Linking the data into a linked table works fine (fields formatted as text).
All the cyphers and pre-signs (plus/minus) are visible, however the string is
aligned to the left like text. However, I wish to use the numbers in
calculations, eg. would have to use them not as text but as Double.
I think the problem lies in the thousand-commas but I have no idea how to
get this left aligned string (the amount) interpreted as a double number data
type.
Many thanks for your help.
I am trying to link a tab-delimited *.txt file into access.
The data contains amounts such as
-1,560.87
Linking the data into a linked table works fine (fields formatted as text).
All the cyphers and pre-signs (plus/minus) are visible, however the string is
aligned to the left like text. However, I wish to use the numbers in
calculations, eg. would have to use them not as text but as Double.
I think the problem lies in the thousand-commas but I have no idea how to
get this left aligned string (the amount) interpreted as a double number data
type.
Many thanks for your help.