nacnudus/tidyxl

Custom number format misinterpreted as date?

Closed this issue · 1 comments

nacnudus commented

#,##0_M_M_M;#,##0_M_M_M;_(@_M_M_M is being interpreted as date. Excel doesn't render the numbers as dates.

Sheet "Table 11" of 2015.xlsx.

tidyxl::is_date_format("#,##0_M_M_M;#,##0_M_M_M;_(@_M_M_M")
# [1] TRUE
da11an commented

Similar: I have a custom number format (0.0############E-0) that is being interpreted as a date. It is not. While custom number formats are often used for dates, I don't think this should be assumed.