Writing NaN

Created originally on Bitbucket by durden (Luke Lee)

I've written the value float('nan') to a spreadsheet, and it doesn't seem like NaN is represented correctly. The cell comes back as 0 after opening the resulting spreadsheet. Should NaN be represented something like this in Excel?