WIN99 to .CSV (Loss OF Decimals)

Chris0381 · #1 (**permalink**) 05-27-2006, 09:55 AM

Lools like when I outputed to a .CSV file I lost my decimals in the frequencies. What I did was create a new column and divided column "E" by 1000000
I believe to get the proper frequencies.

Is this a bug in the new Office 97 beta or is this whats needed doing for all versions of Excell.

Thanks

TES · #2 (**permalink**) 05-27-2006, 11:29 AM

I have no idea of what you mean when you mention "proper frequencies".

It seems to me that the frequencies in the exported .csv file are identical to those displayed on the WIN99 screen. It's the units that are different - Hz vs. MHz.

Chris0381 · #3 (**permalink**) 05-27-2006, 11:48 AM

I meant office 2007 not 97.

What happened is when I converted to .CSV is that I lost the decimal in all my frequencies. Forinstance 37.08 became 37080000 and 151.385 became 151385000 in the frequency column. Must be a setting of some sort out of whack.