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

  • Thread starter Thread starter new user
  • Start date Start date
One reason could be that the column isn't wide enough. Try widening the
column.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Samsung’s Galaxy Note Unpacked 2016 (Note 7 Launch) 39
Why The Result Show Like 00:00, Access 2007 2
Calculating time 3
Subtract day and time w/o weekends or holidays 2
Adding Time 11
Time Format to Text Output - A Tough One ! 4
Excel Excel spreadsheets opening at top instead of bottom. 4
running difference between adjacent records in report 1

Back
Top