Hi George, via135;

Tks for the respond. However, i dun see 'Trailing minus for negative
numbers' in the 'Advanced' button' in either Office 2000 or Office 2003 :(

"George" wrote:

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 !