Best System Error Solution: Display Negative Numbers [Solved]

Thursday, 29 September 2016

Display Negative Numbers

I am trying to display a large negative number without using scientific notation.
For example;

-1E+308

Keys to the Problem Display Negative Numbers

Not sure if I understand. But I'd think it would obviously have to be a text string, given the size of the number. I would approach the problem by separating the mantissa and the exponent, and then translating the exponent into a series of 0's; then concatenating
the two; perhaps adding thousands separators at the appropriate place in the sequence of 0's.

This macro seems to work:

============================
Function BigNum(N As Double) As String
BigNum = Format(N, "#,##0")
End Function
==========================

=BigNum(B1) where

B1: =A1*10
A1: -1.23E+307

-123,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000

To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Recommended Method to Fix the Problem: Display Negative Numbers:

How to Fix Display Negative Numbers with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system. Open it, and it will perform a scan for your system. The junk files will be shown in the list.