Re: Negative numbers in Excel

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

Posted by Robert G Laurin on June 15, 2012 at 08:04:12:

In Reply to: Re: Negative numbers in Excel posted by Jim Barbaruolo on June 15, 2012 at 06:00:44:

That is what I do...

Let ExcelNumber$ = Strip(Str(ABS(MyCometNumber)))
If MyCometNumber < 0
  Let ExcelNumber$ = '-' + ExcelNumber$
Endif

The trick is the ABS that removes the sign altogether and simplifies the code. Still too bad that after so many years Excel still can't tell a number is negative with a trailing minus.

Enjoy !

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 ]