Formula Problem???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There is an excel sheet that I have for time sheets and the date is supposed
to automatically fill out when I fill in the top Date. It works for a
certain date and then in a date from 10/4/2007 to 10/17/2007 it is displaying
everything after 10/10/2007 to appear as ########. Has anyone run into this
problem?
 
Have you tried adjusting the column width to make it wider?

Hope this helps.

Pete
 
Thanks...I can't believe the solution was so simple. They should have a
simple faq for for us Id10 t users....lol

It should say if you see the following ###### just resize the column....lol

Again thank you so much.
 
You're welcome - thanks for feeding back.

I suppose with this it is a case of once learnt, never forgotten.

Pete
 
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

Update cell value based on name and specific date 1
Excel Dragging countif formula with changing criteria 3
Scrabble Value calculation for Welsh words 0
Excel Help with dates 2
How to calculate diffrence in dates in days and Hours 6
Excel Help with date adding formulas! 7
Changing dates across multiple worksheets 5
formula required (2nd time) 6

Back
Top