ATTENTIONThis FlexSim Community Forum is read-only. Please post any new questions, ideas, or discussions to our new community (we call it Answers) at https://answers.flexsim.com/. Our new Question & Answer site brings a modern, mobile-friendly interface and more focus on getting answers quickly. There are a few differences between how our new Q&A community works vs. a classic, threaded-conversation-style forum like the one below, so be sure to read our Answers Best Practices. |
flexsim.com |
#1
|
||||
|
||||
Number format of the state / summary report
Hello community,
after generating a state report, i have to "clean up" the excel table because of a weired number format (in most cases the real values are multiplied by 1.000.000). I've heard there is a little trouble with number format between the german und american number formats in excel. Could this be the reason? Is there a way to set the number format in FelxSim or do I have to work it through in Excel? Greetings form germany, FlorianK |
#2
|
||||
|
||||
Florian,
unfortunately this is a setting you will have to change in Excel. Depending on what Excel version you are using you will find an "International" tab under "Options" where you can specify both, the decimal seperator and the thousands seperator (Office 2003). In Office 2007 you have to got to "Excel-Optionen/Erweitert" (assuming you are using a German Excel). You have to uncheck the box to use operating system settings for these two and have to specify them yourself. Hope that helps Good luck Ralle aka Ralf Flexsim |
The Following 2 Users Say Thank You to RalfGruber For This Useful Post: | ||
Sebastian Hemmann (04-05-2011) |
Thread | Thread Starter | Forum | Replies | Last Post |
State report based on the operational time | Simon Farsah | Q&A | 8 | 06-07-2011 01:42 AM |
CAD's STEP format | Kenny Macleod | Q&A | 4 | 03-09-2011 04:23 PM |
How to change Table format from int to str | Nischith Kashyap | Q&A | 4 | 03-03-2011 08:23 AM |
how to get number of itemtype | Vic Li | Q&A | 11 | 08-19-2009 11:20 PM |
Object order in the summary report | AlanZhang | Q&A | 4 | 10-16-2007 05:50 PM |