View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pk
 
Posts: n/a
Default "find and replace" negative numbers

i have one columns of numbers which displays negative numbers in this format,
300-, this is after import from legacy conversion program. In Excel, how can
i convert this negative format from 999- to -999.


Tks !