excel 2010 - How to enter a number in Scientific notation in a cell
I'm trying to enter:
-1.79769313486231E308
into a cell but keep getting an error message.
How can I enter this number
-1.79769313486231E308
into a cell but keep getting an error message.
How can I enter this number
The problem is the negative.
ASKER
Okay. I got rid of the negative.
I would like to convert this number into "number" format with commas separating the thousands places.
I would like to convert this number into "number" format with commas separating the thousands places.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm learning VBA. My purpose for doing this is just to see the actual numbers written out in "human" format. I don't understand scientific notation.
I'm trying to get a grasp of how large these numbers are:
Single data type
A data type that stores single-precision floating-point variables as 32-bit (4-byte) floating-point numbers, ranging in value from -3.402823E38 to -1.401298E-45 for negative values, and 1.401298E-45 to 3.402823E38 for positive values. The exclamation point (!) type-declaration character represents a Single in Visual Basic
Double data type
A data type that holds double-precision floating-point numbers as 64-bit numbers in the range -1.79769313486231E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values. The number sign (#) type-declaration character represents the Double in Visual Basic.
I'm trying to get a grasp of how large these numbers are:
Single data type
A data type that stores single-precision floating-point variables as 32-bit (4-byte) floating-point numbers, ranging in value from -3.402823E38 to -1.401298E-45 for negative values, and 1.401298E-45 to 3.402823E38 for positive values. The exclamation point (!) type-declaration character represents a Single in Visual Basic
Double data type
A data type that holds double-precision floating-point numbers as 64-bit numbers in the range -1.79769313486231E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values. The number sign (#) type-declaration character represents the Double in Visual Basic.
Not sure what you mean, what is it you want to know?
Is it to understand the different data types in Excel/VBA?
Scientific notation is 'human' format.
Is it to understand the different data types in Excel/VBA?
Scientific notation is 'human' format.