Excel 2007: Why do I see ########?
Thread poster: David Jessop

David Jessop  Identity Verified
Spain
Member
Spanish to English
+ ...
Jan 29, 2010

Hello...

I imagine this is an easy Excel question for someone who knows. I have a date field in my Excel accounting field and now instead of the date I see ########. This seems to have occurred randomly. I know that the dates are not lost because if I hover my mouse over the cells, the dates appear in a floating box; also, if I copy the text and paste it into another application, the dates appear rather than the #######. Thanks for any help on solving this!

Best wishes,
David


Direct link Reply with quote
 
Laurent KRAULAND  Identity Verified
France
Local time: 04:13
French to German
+ ...
Your cells are not wide enough... EOM Jan 29, 2010

... and Excel will display these # to show that there is content in such cells, but that it cannot be shown in full.

[Edited at 2010-01-29 21:33 GMT]


Direct link Reply with quote
 

David Jessop  Identity Verified
Spain
Member
Spanish to English
+ ...
TOPIC STARTER
Fool :-) Jan 29, 2010

Thanks ScottishWildCat, don't I feel like a fool now.

Saludos.

David


Direct link Reply with quote
 

Pablo Bouvier  Identity Verified
Local time: 04:13
German to Spanish
+ ...
Excel 2007: Why do I see ########?" Jan 29, 2010

David Jessop wrote:

Thanks ScottishWildCat, don't I feel like a fool now.

Saludos.

David


Basic motive for this is the one mentioned above by ScottishWildcat, but they may exist some others. One of them is that an operation result lands in a previously wrong formatted cell, like a number in a cell defined for dates.

[Editado a las 2010-01-29 21:42 GMT]


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Excel 2007: Why do I see ########?

Advanced search






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search