Posted by Bob A on June 15, 2012 at 10:56:16:
In Reply to: Re: Negative numbers in Excel posted by Robert G Laurin on June 15, 2012 at 08:04:12:
Using the Text Wizard
In XL02/03 (Windows) you can select one column of your data, choose Data/Text To Columns..., click OK, OK, then Advanced. Check the treat trailing minus as negative checkbox, then Finish.
for those of us who are as up-to-date on their MS Office as we are on COMET :)
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.