Why does my data file keep changing from date/time to numbers or text in Grapher?

Grapher allows you to save your data file with dates and times. If your graph appears empty or your date and times change to numbers or text when you reopen the file, you may be saving to a format that does not support date and time in the worksheet. The BLN format is one of these formats. If your data is saved to a BLN file, please follow these steps to change it to a format that does support date/time:

  1. Click the File | Open command in Grapher.
  2. Select the BLN file and click Open.
  3. Highlight the column that is supposed to be date/time format.
  4. Click the Data Tools | Data | Text to Number command to convert any text to numbers.
  5. Click the Data Tools | Format | Format Cells command.
  6. In the dialog, select Date/Time and set the Date/Time format. Click OK.
  7. Click the File | Save As command.
  8. Change the Save as type to DAT Data (*.dat), XLS Excel Spreadsheet (*.xls), or XLSX Excel 2007 Spreadsheet (*.xlsx). Type a new File name and click Save.


The data will now be saved in a format that supports date/time format in the worksheet. You may need to update your graphs to point to this new file.


Updated October 08, 2018

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.