#######?

I bought a new computer with an updated version of Excel post transfering my
old spread sheet to office 2003 I've found most of my dates now now read
#######. I have yet to figure out a way to insert a date (ie 7/9/05) without
this same issue occuring.

boblock, the column is not wide enough to display the data, widen the column
or maybe change the formatting, I have seen dates change formatting when you
open a file in a newer version

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"boblock" <[email protected]> wrote in message
news:[email protected]...
> I bought a new computer with an updated version of Excel post transfering
my
> old spread sheet to office 2003 I've found most of my dates now now read
> #######. I have yet to figure out a way to insert a date (ie 7/9/05)
without
> this same issue occuring.

Just to add to Paul's response.

I bet your short date format is different in the new pc than in the old pc.

Using some formats, excel will pick up that windows format and use that.

You may want to fiddle with your windows setting
windows start button|control panel|regional settings
to change that date format.

(I like mm/dd/yyyy (leading 0's and 4 digit years). I've received workbooks
that were developed on pcs that used m/d/yy as the format. The column widths
had to be widened for me (and narrowed for those other users).)



boblock wrote:
>
> I bought a new computer with an updated version of Excel post transfering my
> old spread sheet to office 2003 I've found most of my dates now now read
> #######. I have yet to figure out a way to insert a date (ie 7/9/05) without
> this same issue occuring.

--

Dave Peterson

I like yyyy-mm-dd myself, just wish the data entry was easier,
but it sure is easier read, and I don't really type all that many dates.
When it's sorted it really looks sorted, and it doesn't wobble around.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave Peterson" <[email protected]> wrote in message news:[email protected]...
> Just to add to Paul's response.
>
> I bet your short date format is different in the new pc than in the old pc.
>
> Using some formats, excel will pick up that windows format and use that.
>
> You may want to fiddle with your windows setting
> windows start button|control panel|regional settings
> to change that date format.
>
> (I like mm/dd/yyyy (leading 0's and 4 digit years). I've received workbooks
> that were developed on pcs that used m/d/yy as the format. The column widths
> had to be widened for me (and narrowed for those other users).)
>
>
>
> boblock wrote:
> >
> > I bought a new computer with an updated version of Excel post transfering my
> > old spread sheet to office 2003 I've found most of my dates now now read
> > #######. I have yet to figure out a way to insert a date (ie 7/9/05) without
> > this same issue occuring.
>
> --
>
> Dave Peterson

It was a fight to get my coworkers to use 4 digit years!

I used to irritate them by asking what a date of 01/02/03 meant?

(when in doubt, a format that spells out the month may be the way to go.)


David McRitchie wrote:
>
> I like yyyy-mm-dd myself, just wish the data entry was easier,
> but it sure is easier read, and I don't really type all that many dates.
> When it's sorted it really looks sorted, and it doesn't wobble around.
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Dave Peterson" <[email protected]> wrote in message news:[email protected]...
> > Just to add to Paul's response.
> >
> > I bet your short date format is different in the new pc than in the old pc.
> >
> > Using some formats, excel will pick up that windows format and use that.
> >
> > You may want to fiddle with your windows setting
> > windows start button|control panel|regional settings
> > to change that date format.
> >
> > (I like mm/dd/yyyy (leading 0's and 4 digit years). I've received workbooks
> > that were developed on pcs that used m/d/yy as the format. The column widths
> > had to be widened for me (and narrowed for those other users).)
> >
> >
> >
> > boblock wrote:
> > >
> > > I bought a new computer with an updated version of Excel post transfering my
> > > old spread sheet to office 2003 I've found most of my dates now now read
> > > #######. I have yet to figure out a way to insert a date (ie 7/9/05) without
> > > this same issue occuring.
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

Typically this indicates that the column is not wide enough to
display the date. Widen the column and it should go away.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"boblock" <[email protected]> wrote in message
news:[email protected]...
>I bought a new computer with an updated version of Excel post
>transfering my
> old spread sheet to office 2003 I've found most of my dates now
> now read
> #######. I have yet to figure out a way to insert a date (ie
> 7/9/05) without
> this same issue occuring.