Why do I get this ###### instead of 11:00 p.m. in formatted cell?

  • Thread starter Thread starter new user
  • Start date Start date
Always supply your formula and the values of the input cells

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
 
Not to forget: if cell contains fomula that evaluates time value and
result turns to be negative, it will be shown as ###### no matter how
wide column is.

Cheers
 
Back
Top