date format

  1. C

    Create a cell where a string of numbers are entered, and it formats to a date.

    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!
  2. B

    Date manipulation problem VBA, HELP pleaase!

    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...
  3. A

    Using dates in Excel formulas

    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...
  4. girapas

    Automatically convert date entry format

    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
  5. P

    VBA Userform date format issue - dd/mm/yyyy

    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 =...
  6. D

    formula for unique date range - 15th - 14th of each month as opposed to full calendar months

    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...
  7. N

    Keeping date format

    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>...
  8. S

    Date Formats not picked up in Pivot Table

    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...
  9. D

    UK format date in userform textbox

    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...
  10. R

    Date Formatting issues when using a table

    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)...
  11. B

    Excel VBA date reversed

    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...
  12. A

    Excel Date Formatting VS Regional Settings

    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...
  13. K

    Day/date formatting

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

    DateFormat,Date,SQL

    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...
  15. R

    Inserting Date into Userform Testbox

    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...
  16. C

    Change Date Format in Excel

    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 :)
  17. M

    Ctrl-Shift-3 to short date format

    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...
  18. N

    incorrect date format in historical stock chart

    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...
  19. S

    VB for correct date format from User Form

    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...
  20. C

    Format cells based on format in combobox

    Hello, I'm looking to format (or convert) cell values based on the format indicated in the combobox. Below is my code. Each of the comboboxes contains a part of common date formats (e.g. 'mm', 'yyyy', 'dd', '/', '.', etc). I've stepped through and it's reading Date1 and Date2 in the proper...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top