Thread: Convert to negative numbers in whole worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
igbert igbert is offline
external usenet poster
  
Posts: 44
Default Convert to negative numbers in whole worksheet
I have data imported from another file to Excel with negtive numbers show as
478.56- and so on.

Is there a macro to covert all these numbers to a format (478.56)?

Thanks

Igbert
Reply With QuoteReply With Quote