dATES IN BOXES

  • Thread starter Thread starter mARK
  • Start date Start date
M

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
 
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)
 
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
 
Back
Top