Data Import - formatting

I'm exporting accounting data fm a business system into Excel. Negative
dollar amounts come into Excel in this format "12,345.67-". The trailing "-"
is formatting at text and not currency thus my numbers aren't adding up.

Is there a way I can convert "12,345.67-" to "-12,345.67"?

tks,
steve

You can use a formula like this, to convert the negative ammounts and leave
the possitive the same:
=IF(RIGHT(A2,1)="-",--("-" & LEFT(A2,LEN(A2)-1)),A2)

Hope this helps,
Miguel.

"sjs" wrote:

> I'm exporting accounting data fm a business system into Excel. Negative
> dollar amounts come into Excel in this format "12,345.67-". The trailing "-"
> is formatting at text and not currency thus my numbers aren't adding up.
>
> Is there a way I can convert "12,345.67-" to "-12,345.67"?
>
> tks,
> steve

Miguel,

That's awesome, thanks!!

"Miguel Zapico" wrote:

> You can use a formula like this, to convert the negative ammounts and leave
> the possitive the same:
> =IF(RIGHT(A2,1)="-",--("-" & LEFT(A2,LEN(A2)-1)),A2)
>
> Hope this helps,
> Miguel.
>
> "sjs" wrote:
>
> > I'm exporting accounting data fm a business system into Excel. Negative
> > dollar amounts come into Excel in this format "12,345.67-". The trailing "-"
> > is formatting at text and not currency thus my numbers aren't adding up.
> >
> > Is there a way I can convert "12,345.67-" to "-12,345.67"?
> >
> > tks,
> > steve