ieee754 single precision numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

importing and exporting.
How do i convert these numbers to general number format and the reverse?
 
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.
 
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
 
Back
Top