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

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

One reason could be that the column isn't wide enough. Try widening the
column.

--
Biff
Microsoft Excel MVP

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

Always supply your formula and the values of the input cells

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"new user" <new wrote in message ...
|

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

On 15 ñåï, 19:43, new user <new wrote:


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