formatting text

[moemoe77]

I have a value that was imported into excel in a comma delimited file
with the negative sign after the value (on the right side). I am
trying to find a function, subroutine, anything that will make excel
recognize this value as a negative. The value is supposed to be in
currency, but is shown as general(text). This .csv file is to be
imported into a SQL database, which also does not recognize this
value. The database actually shows these values as text when imported
as the .csv file. If imported as .xls file, the values are null.
Yet, Access will recognize the value as negative. Thanks in advance
for any suggestions.

 

[Andy B]

moe

Try this in the adjacent cells:
=VALUE(RIGHT(D9,1)&LEFT(D9,LEN(D9)-1))

Andy

 

[moemoe77]

Thanks for the suggestion. I found something similar after I posted
my msg and it works, just not in the way I need it to. The values are
imported into the .csv file w/ the negative on the right side and when
I try to use a formula in the cell w/ the negative value (where I need
it), it creates a circular reference. I found a couple of posts
dealing w/ negative text and in one, there was a link for a utility
program that corrects the problem. Thanks again.