Calc: Format of column changes when I close the spreadsheet

[MarghekKoth]

I have a column with formula like:

=IF(ISBLANK(E1),(WORKDAY(A1,5,K1:K3)-TODAY()),"")

I set the format to numbers with no decimal places. However each time I open the spreadsheet, the format has change to date, and I have to reformat the column.

How can I keep the format that I want?

[PKG]

@MarghekKoth

However each time I open the spreadsheet, the format has change to date,

This actually only happens if the format code is General and not 0.

[MarghekKoth]

Many thanks. that’s sorted it.