View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sjs
 
Posts: n/a
Default 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