Page 1 of 1

Number Format and Excel

Posted: Fri Oct 16, 2009 4:21 pm
by Camila
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.

Posted: Sat Oct 17, 2009 10:50 am
by bob@vensim.com
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.