Format the cell as a date.

"BertP" wrote in message
...
How do I get =NOW{} in a cell that show a date that changes whenever I
open a sheet? It worked before. What am I now missing? I seem to get a
number in the cell.