there are extra numbers in date area

Excel Excel 2007
January 19, 2011 at 09:38:21
Specs: Windows XP
I have a spreadsheet with a date row on the top of the page. For some columns (i.e. dates) there are other dates appearing other than what I type in there. I have tried clear all but the erroneous dates continue to appear. Please advise.

See More: there are extra numbers in date area

Report •


#1
January 19, 2011 at 10:50:36
Sunday as 1 through to Saturday as 7

Do you have any Macros running?

MIKE

http://www.skeptic.com/


Report •

#2
January 19, 2011 at 11:47:14
No Macros running that I am aware of. I started with someone else's spreadsheet and re-formulated from there. How do I check to see if it is a Macro? I'm not real good on the Excel thing (as you can tell). Thanks.

Report •

#3
January 19, 2011 at 12:45:15
I'm not that great with macro myself, hopefully someone with a bit more expertise will correct me if I go to far wrong.

Try, Alt+F11 to get to the Visual Basic Editor

Then Ctrl+R to bring up the Project Window (should be on leftside of screen) if it's not already there.

Now select your project, which should be something like: VBAProject(workbook name)

See what's listed.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
January 19, 2011 at 13:28:00
Since we can't see your spreadsheet from where we're sitting, you need to be a bit more specific.

What do you mean when you say "there are other dates appearing other than what I type in there"?

Are you saying that when you type a specific date in a specific cell a different date appears in that same cell?

What do you mean when you say "I have tried clear all but the erroneous dates continue to appear"?

What is "clear all"?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#5
January 19, 2011 at 13:33:24
Yes, what I mean by other data is like 9\3 will appear underneath my date of 12\1 and if I do clear contents of the cell then it clears the 12\1 I put in but not the 9\3. It does seem like it is either a Macro or a hidden formula or cell?

Report •

#6
January 19, 2011 at 16:37:48
Enter something directly in the cell that shows the "extra dates".

I'm guessing that if it is a hidden formula you will overwrite it.

If it's a macro, it'll go back doing whatever the macro tells it to do.

Maybe that will point us in the right direction.

Macros can be hidden and protected so you may not be able to find it (easily).

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question