"find and replace" negative numbers
I'm not sure how you are importing this because excel has automatic
detection of trailing minus signs and converts them to normal numbers
If the numbers are in one column try highlighting it then use
Text To Columns
Step through the wizard (Click NEXT twice)
Notice the 'Advanced' button - click on that and make sure that the
'Trailing minus for negative numbers' is ticked on
Then click OK and Finish
Hope it helps
George
pk wrote:
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 !
|