dATES IN BOXES

[mARK]

hi All:

THis is just killing me; why is it that when I enter in a
number into my spreadsheet the it comes up with month
attached. For examply when I enter in the number 4 it
populates the field with 4-Jan. Please help this is just
a real pain in the asss

 

[Chip Pearson]

Mark,

Does this happen in every cell or just a few. The formatting of
the cell is probably set to a date format. Select the problematic
cells, go to the Format menu, choose Cells, then the Number tab,
and choose General.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Mark Maiden]

I've only got one cell for the week number in the spreed
sheet. Like I said that it worked correctly for a few
years in Windows95. Now it doesn't but now I'm using XP
Pro.

I've tried what you said but it still does not work I get
the same error #NAME?

Mark Maiden