Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ieee754 single precision numbers
importing and exporting.
How do i convert these numbers to general number format and the reverse? -- staff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ieee754 single precision numbers
IEEE 754 deals the way numbers are stored in memory on a computer and the
math the manipulates these numbers. When you import and export numbers you are using digits (0-9) that represent the numbers. If you havve 8 bit memory (or byte) in the computer the number will be stored as ones and zeroes 00010100 which equals 20. You don't import the ones and zeroes you import the digits that represent the number which is 20. This applies to IEEE 754. IEEE 754 numbers are scientific notation numbers such as 1.50E+00. You import and export the scientific notation that represents thes number. You don't need to convert these numbers to general numbers just change the format in which the number are displayed in excel. "staff" wrote: importing and exporting. How do i convert these numbers to general number format and the reverse? -- staff |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
ieee754 single precision numbers
Your question is not clear. "General" is a display format, while IEEE 754 is
a method of storing a number. Please clarify what you want. http://www.cpearson.com/excel/rounding.htm gives details on IEEE 754 double precision storage. Single precision is similar, but with 8 bits (11 for DP) for the exponent and 23 bits (52 for DP) for the mantissa. Jerry "staff" wrote: importing and exporting. How do i convert these numbers to general number format and the reverse? -- staff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to return a single value for a range of numbers | Excel Worksheet Functions | |||
Range of numbers in a single cell | Excel Discussion (Misc queries) | |||
Adding numbers in a single cell | Excel Worksheet Functions | |||
can a single cell contain multiple numbers? | Excel Worksheet Functions | |||
Precision displayed does not match precision in cell | Excel Discussion (Misc queries) |