Problem with excel data appearance.

I am viewing an excel file shared by one of my teammates. All date columns having values like 08/06/2013  08:00:00 appear as ############ in the cells. Any suggestions what could be the problem?
sukhoi35Asked:
Who is Participating?
 
RaminTechnical AdvisorCommented:
Are you using the same version of Excel ?

If no, double-click the line between the headings like below.

1.png
0
 
Martin LissOlder than dirtCommented:
As Ramin implied, you get the #### because the column is too narrow to show the whole value.
1
 
OddyWriterMr.Commented:
Additional information:

Sometime, Excel shows ##### because the cell has a negative date or time value:
If your information is date or time:
1. Verify dates and times are positive values when you’re using the 1900 date system.
2. Use a formula to subtract dates or times correctly to avoid negative date or time value results.
3. Change negative formula results that are formatted as dates or times to a different number format.
0
 
sukhoi35Author Commented:
Thank you for your time and efforts!
2
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.