View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Serge[_4_] Serge[_4_] is offline
external usenet poster
 
Posts: 4
Default Anomaly, can't format cell

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.