Anybody knows how to use MS Excell to calculate/represent an integer number > 16 digits. For example, I was trying to calculate 3^32. This is a number > 16 digits and with last digit being 1. However, my Excel gives me 1,853,020,188,851,840. And if you continue to go 3^33 ... and larger index, the last digits are all wrong. I always has the impression that Excel is "double precesion" that mean it can handle 32 digits of a number. Maybe this is a bug? Thanks. www.ddhw.com
|