Number Format and Excel

Camila · Post by **Camila** » Fri Oct 16, 2009 4:21 pm

Hello,

I am trying to import data from Vensim to Excel, but when the numbers exceed a million, Vensim uses for example 1M, and I can't get the other digits in Excel.

Does anyone know how to make Vensim work with scientific notation or at least including all the digits of a number?

Thank you!

Camila.

bob@vensim.com · Post by **bob@vensim.com** » Sat Oct 17, 2009 10:50 am

If you are using a very old version of Vensim you will need to right click on the Table tool and select Scientific for the number format. Otherwise Vensim puts numbers to the clipboard in an excel BIF format and they paste in as numbers regardless of the format they display in Vensim. If you can't get copy/paste to work you might try exporting the dataset.