Thread: text to Column and amount from -ve to +ve.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shital shah shital shah is offline
external usenet poster
  
Posts: 61
Default text to Column and amount from -ve to +ve.
I export data from other prog. To excel and converting to text to column. I
have fields like Date, Ref No., Item, Opening Bal, Pending Bal. In my
Opening Bal, Pending Bal. column some amount comes in €“ (-ve) and some comes
in + (+ve) I want to convert €“ve amount into +ve and +ve into €“ ve .
Is possible through program. Any help.
Thanks
****al

Reply With QuoteReply With Quote