Re: Negative numbers in Excel


[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]

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 :)


Follow Ups:



Post a Followup

Name:
E-Mail:

Subject:

What is the name of the main Signature System's Product?  

Comments:

Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):





Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.


[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]