• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

Unable to Change Date in Excel

Hello Experts,

For some reason I'm unable to change the date in the attachment.

I'm trying to change the date under other expenses sheet, but it won't let me.

Can anyone figure out why?

Cheers
Transaction-Listing-2012-2013-1-.xlsx
0
cpatte7372
Asked:
cpatte7372
  • 4
  • 3
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Select the date cell and go to

Data > Data Validation

Where there is a restriction imposed on the dates to be entered.
0
 
cpatte7372Author Commented:
Hi ssaqibh,

I don't have the option the Data Validation option.

I'm running Office 2007

I can't think of a reason why I can't change the date to say, 17/04/2013. However, I can the date to anytime in January.



Weird
0
 
Saqib Husain, SyedEngineerCommented:
In the ribbon menu there is a "Data" menu item. When you select it there is a "Data Validation" in the sub menu within the "Data tools" group.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
cpatte7372Author Commented:
his ssaqibh,

Where can I find the ribbon menu?

Cheers
0
 
cpatte7372Author Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for cpatte7372's comment #a39251397

for the following reason:

Cheers mate
0
 
Saqib Husain, SyedEngineerCommented:
You selected the wrong comment.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now