Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

auto fill dates in excel


  • Please log in to reply

#1
The old Submariner

The old Submariner

    Member

  • Member
  • PipPip
  • 43 posts

I have just set up an accounts page in excel so that I can keep track of our spending.  I enter for example "01/01/2012 move to the adjacent column and enter the amount.

I have tried to enter a date formula to save me having to enter the full date each time I make an entry, but if I type "02" and then move to the adjacent column to enter the amountit reads "02/01/1900 , can anyone tell me how to get round this please?


  • 0

Advertisements


#2
Vi-Sion

Vi-Sion

    Member

  • Member
  • PipPip
  • 76 posts
Hello Submariner a sreeshot would be very helpful to see what you've done and understand what your trying to do .
  • 0

#3
SleepyDude

SleepyDude

    Trusted Helper

  • Malware Removal
  • 4,149 posts

Hi,

 

You can type the current date using the keyboard shortcut CTRL + ; to get the ";" in some keyboards you have to use CTRL + SHIFT + ;

 

Excel have some functions for date and time but they will change in every calculation, probably something you don't want.


  • 0

#4
The old Submariner

The old Submariner

    Member

  • Topic Starter
  • Member
  • PipPip
  • 43 posts

Hi Vi-Sion, 

  not being too au fait with this computer malarkey not sure how to add a screen shot


  • 0

#5
Vi-Sion

Vi-Sion

    Member

  • Member
  • PipPip
  • 76 posts
Usually u can take a screen shot by clicking fn+prtsc and then open paint paste it there,save it then upload it.
  • 0

#6
MichaelMarks

MichaelMarks

    Member

  • Member
  • PipPip
  • 31 posts

I still don't get it dude. You better put some screenshots or video for us to understand.


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP