date format

Hello, everyone! I hope you are having a great day today! I am trying to manipulate data downloaded from a bank file into a useable format. What adds a level of difficulty is that I am trying to do this for someone who has almost zero Excel knowledge so I'm trying to automate this as much as...

Hello! Is there a way to to set a cell to format a string of numbers like 03012009 into the date 03/01/2009 as you type it in? I do a lot of data entry, and this would help to speed up filling out our excel sheets. Thanks!

Hi there, It would be very kind of you if you had any solution to this problem :) : In the A Colomn I have months over differents years In the B Colomn I have related turnovers In C1 I have a list made out of the different months (Jan-10, Feb-10, ..., Mar-13) I want that when you select a...

I have long table which looks like this: <tbody> A B C D 1 Date Order no. Value State 2 3 </tbody> When I need to get a subtotal of the values state-wise I use the array forumula: ={Sum(if(D2:D200="Name of State",C2:C200,0))} Now, when I use the same formula for a month-wise...

In a cell, a user enters a date in this format: ddmmyy How can that entry be automatically converted in a format like: dd/mm/yyyy after the user hits Enter key. Thanks in advance

Dear experts, I am trying to enter a European date in my userform but the result is always in US date format. Here is the code I got from an internet template: ____________________________________________ Private Sub cmdEnter_Click() Dim iRow As Long Dim ws As Worksheet Set ws =...

Hello I have two columns: date (yyyy/mm/dd) and data associated with each date. I'd like to group by month that ties in with our reporting period, which is not calendar months but mid months - 15th - 14th. Is there a way to easily tell either my pivot table to do this or add a new column with...

Hi, Is it possible to keepa date format regardless of the position of the date in a cell? When I add a space or line (alt+enter) before the date , excel doesn't recognize it anymore, and displays the original input. Example: Hope this is clear. Thanks for reading / helping. Bye <tbody>...

Hello friends, I have inherited a spreadsheet that I need to update soon. It takes data that has a date field and creates a pivot table by month. The person who created it completed it thru February. Now I have added data for March and April, but the pivot tables can not find this new data...

Hi All, I am having trouble with the uk date format in vba. I am using excel 2010 on windows and have changed my regional settings. My textbox is called custom_date and to have the date appear when the userform is launched, I enter the following code: UserForm1.custom_date.Format = Date...

I have created a worksheet that is linked to a sharepoint log. The "created date" column is formated as such: 11/7/2011 4:19:07 PM. I only need the date (for a pivot table), so i created a column at the end of the table and added this formula: =LEFT(Table_owssvr_1[[#This Row],[Created]],5)...

I am using windows 7 and Excel 2007. In Ecel I have a form set up with a textbox to insert the date. I enter the date in the format dd/mm/yyyy which is the same as my format for dates as set up in windows. However when the form transposes this to the worksheet the date is reversed into the...

I have a problem where I am creating excel file with date format of "mm/dd/yyyy" and my machine's regional settings are English (US). Now when my end user downloads my excel (who has English (Canada)) they see the excel file with no issues except the date's messed up due to their regional...

How do I get the date to display in this format please? 8-1-10, Monday Thanks in advance!!

Hi All, I would like to run the following query using date range Start Date = 01/10/2010 dd/mm/yyyy End DAte = 31/03/2011 & 23:59:59 dd/mm/yyyy When I run the Option-1 one using "Parameters" its run ok Option-1 WHERE (((AdmitDate)<=DateAdd("d",1,[End Date])) AND...

I am endeavouring to insert a date into a textbox on a userform, using the following code: Private Sub tbDate_Change() Me.tbDate.Value = Format(Me.tbDate.Value, "dd mmm yy") End Sub I initialized the testbox to reflect the current date; however, when I attempt to alter the date, a...

Hi all Hoping someone can help me with this: I have a column with DOB entries like this Aug 27 1982 - I need it displayed as 27/08/1982. Aug 27 1982 is not a "date format" in Excel so when I try to display it as "Short Date" it does not work, please help? Thanks Caroline :)

Hi I don't tend to post to forums since the oracle (Google) tends to answer most of my questions, but this one I have been wondering about for some years. I love shortcut keys and hate the mouse. I therefore managed to configure my Excel such that I can do pretty much anything with the keyboard...

Thank you for your time. I have downloaded the historical data for the Dow index and have been plotting certain time periods to study in excel2010. The data that I downloaded has date, open, high, low, close, and volume. When I create a chart to show the above data using Insert>Other...

So I now have a nice little user form which will cut down data entry time by vast amounts.... Except the box for date is returning the data in the wrong format... If I enter the date on the userform as 4/2/11 It is entered into the appropriate cell as 2/4/11 which is going to make analysis a...