Can't change birthdate in cell

P

pete5440

I have an client list containing general information including the birthdate.
Out of about 600 names about 20 birthdays show ###### in the cell. If I hover
my cursor over the cell the date shows. If I then change the date, all of the
other cells where the birthdate showed the pound sign change to their correct
dates. However, I cannot save the updates as when I go back none of the
birthdates in question are updated and still show #####. The date format is
mm/dd/yyyy. I have never seen this before and am stumped!
 
K

Kevin B

You just need to widen the column that the dates are in. Whenever Excel has
a number that it cannot display fully it replaces the numbers with #'s
symbols.
 
P

PCLIVE

Chances are your column isn't wide enough to display the full date. Try
widening the column.

Regards,
Paul
 

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

changing the formatting of birthdates 2
Word VBA - Automatic change content of a cell in table using dropdown list 5
mail merge 2007 word labels 1
Excel date formate doesn't change 0
age groups 8
Excel 2002: How to make the date format uniform ? 1
Calculating How Old Someone Will Be in a certain year 2
Conditional formatting of date-cell - 2007 5

Top