I have a code exporting on excel using spreadsheet gem:

<ss:Style ss:ID="s1">
  <NumberFormat ss:Format="m/d/yy"/>
</ss:Style>

<Row>
  <Cell ss:StyleId="s1">
    <Data ss:Type="Date"><%= DateTime.now %></Data>
  </Cell>
</Row>

Using Libre Office, it give a proper format which is expected.

But when it open into Windows using Microsoft office, is doesn't open and shows the following error.

How can I fix this issue? Thanks!