Re: [EnergyPlus_Support] trouble in converting weather data (*.csv) by EXCEL

[Linda Lawrie <linda@xxxxxxxxxx>]

The problem is that the cell is being interpreted as a date.  I did a 
"turn off automatic date formatting" in Excel help and came up with 
this possible solution:

Format cells using a different locale

The formats for Date, Time, and Special can be set to conform to 
different locales.
    * Select the cells you want to format.
    * On the Format menu, click Cells, and then click the Number tab.
    * In the Category box, click either Date, Time, or Special.
    * In the Locale (location) box, select a locale to see sample 
formats for that locale in the Type box.
    * Select the desired number format from the Type box.
    * Click OK.
Choosing a US locale might do the trick?

Or, you could edit with a text editor (Wordpad but not Notepad -- 
because of the file size) and convert it that way.


Linda

EnergyPlus WebSite: http://www.energyplus.gov
Owner: EnergyPlus_Support list
Member: EnergyPlus Development Team



[Non-text portions of this message have been removed]



The primary EnergyPlus web site is found at:
http://www.energyplus.gov

The group web site is:
http://groups.yahoo.com/group/EnergyPlus_Support/

Attachments are not allowed -- please post any files to the appropriate folder in the Files area of the Support Web Site.

EnergyPlus Documentation is searchable.  Open EPlusMainMenu.idf and press the "search" button.
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/EnergyPlus_Support/

<*> To unsubscribe from this group, send an email to:
    EnergyPlus_Support-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/