The cells contains text instead of numbers. You can't format text (even if
it looks like a number).

What is the RTD function.

--
Regards,
Tom Ogilvy

"Serge" wrote in message
...
Neight fom GUI nor VBA.

searched google groups found semi-solution:
<<
Type the number 1 in any empty cell (make sure that the
NumberFormat of the
cell with the number 1 is General or Number)
Copy it
Select all problematic date cells
Paste Special = Operation | Multiply


It worked. Question is why and how to fix it.
The cell formula contains RTD function.

Thank you.