date format

  1. tlc53

    Set Date Format in VBA Code

    Hi, I have a VBA code which is working great for me, however I want to define the date format on cell A3 to dd.mm.yy How do I incorporate it into this extract of coding? strName = wsA.Range("A1").Value _ & " - " & wsA.Range("A2").Value _ & " " & wsA.Range("A3").Value Thank...
  2. A

    How to format a date

    I had been hating write the code about date & time format. There are a problem as following code, I had tried to using Cdate, DateValue, Val...but not work,anyone solve it. Thks. Sub default_value() Dim fmt As String fmt = "hh:mm:ss yyyy/mm/dd" With Start_date .Enabled = True: .Value = Date...
  3. P

    Convert the date in ISO format

    Hi, I'm struggling to convert the date into ISO format which is giving me wrong results while I compare two different sheet. My inputs are <tbody> 4/9/1984 8/1/2007 F 21006.87 Regular School District 1 Average 34 54 57 57 57 1 4 33.4 18245.93 259616.66...
  4. B

    Checking for Date Format

    Hey i have a column full of dates that i need to arrange in the format dd-mm-yyyy. I do this by this code: Sub ChangeFormat() With ActiveSheet.UsedRange.Columns("D").Cells .TextToColumns Destination:=.Cells(1), DataType:=xlFixedWidth, FieldInfo:=Array(0, xlYMDFormat) .NumberFormat =...
  5. A

    Access upload date format

    Hi All The problem i have is. i have created an excel file with a userform that is a questionnaire. with in this questionnaire are several section where a date is required. once the userform is submitted a worksheet has cells filled in with the userform values. no problems here the problem...
  6. K

    Date format

    Dear Experts, I have a last three months data from 01/11/2017 till 31/01/2018 in which all dates are mentioned like mmm/dd/yy but my default format is dd/mmm/yy. Some dates are showing date format 1/nov/17 and some dates are 13/jan/17. Can any body confirm how to get all dates proper. Best...
  7. B

    Changing default date format from d-mmm

    When typing a date such as 2/19 (m/d or m/dd), the Excel default date format changes it to 9-Feb (d-mmm). Is there a way to change this default? Changing the regional settings does not work as Microsoft would suggest - the d-mmm format doesn't even appear in the settings, but does appear as a...
  8. S

    Excel do not see date format in columns after consolidation

    Hey Guys, I have really strange issue connected to the master tracker, which consolidates data from several other 'individual' trackers. Once I consolidate data, everything from 'individual' trackers flows to master tracker (they look perfectly the same in terms of view, columns, etc.). The...
  9. JonnyAngelo

    Change date format within a column(s) of a listbox

    Hello, So I've been at work on a userform to brush up my skills on vba and i've managed to create a userform with a listbox that displays data from a spreadsheet and gets filtered by some combo-boxes when options are selected. Everything runs well but the only issue i'm having is setting a...
  10. C

    Birthdate Textbox

    - Applicants input their birthdate in a textbox on a userform - There are numerous formats and errors an individual can make when inputting a birthdate Questions - I want the textbox to only allow the input or paste of numbers [0-9] and slashes "/" - I want the textbox to be formatted as...
  11. H

    Cannot apply a consistent DATE format

    Hi fellas, I'm struggling with something seemingly very simple. I have a date column in a terrible format and I cannot apply a normal date format to all rows. I don't really care if it would be mm/dd/yyyy or dd/mm/yyyy as long as it is the same for every entry. Whatever I tried with functions...
  12. N

    Find Cells Containing Date & Reformat DD-MMM-YYYY

    Hi all. Hoping someone can assist me. I am provided with large spreadsheets (that have been created from data held in Access) and have no control over the data provided. In these sheets will be columns that contain dates in a variety of different formats and I need to create VBA that will...
  13. B

    Force TextBox to be Date Format

    https://www.mrexcel.com/forum/excel-questions/317066-force-textbox-date-format.html#post1556884 In reference to this post, I have used the code, except if someone were to just enter 06 and nothing after, it still allows the code to go through. I am looking for an error message to pop up in the...
  14. W

    Covert Years-Months ago date format to no of days/minutes

    Hi, Can anybody help me in converting this excel logic to macro or formula: Requirement- Convert Months/Years/Days/Hours ago time to Minutes., and give ranking to it. I Have excel file with colmn Time and Download count in column D and E, i want to find out average download time per minute...
  15. T

    Issues with cell type conversion

    Hi, I'm having difficulty with excel's automatic recognition of cell formats. I have a column imported from another source that are stored in 'general' format - numbers are stored as text, dates appear as 'dd/mm/yyyy. I am assigning these values to another column in a separate sheet, however...
  16. HawaiianShirts

    Format Cells - Date - Defalt "Locale" Selection Changes

    The Format Cells "Date" settings are behaving... strangely. I regularly pull in data from a reporting system via csv files. The source formatting is always the same, but Excel seems to be seeing something that I am not. When I copy the csv data from the source file to the .xlsx spreadsheet, I...
  17. H

    Change column format to date (day / month / year) with VBA

    Hello, I encounter a minor problem which drives me crazy because I can't find the solution to it. Basically I have a big table and one of the columns contain european style dates (day / month / year). What I want to do is change the date format through VBA so that the full name of the month...
  18. K

    Mail Merge to Word from Excel - Date formatting incorrect on SOME dates

    Hi all, Similar to this post http://www.mrexcel.com/forum/excel-questions/584959-mailmerge-uk-date-format.html I am using Office 2010 and have short date formatted columns in Excel and the field code {MERGEFIELD Anticipated_Start_Date \@ "dddd, dd MMMM yyyy"} in Word - yet some of the dates...
  19. J

    Problem with Date Formatting

    It should be simple, but it's driving me crazy. First of all, i'm brazilian and here standard date is dd/mm/yyyy. Whenever excel gets the chance it autmatically formats my date as north american dates (mm/dd/yyyy)... Example: 06/07/2016 turns 07/06/2016... It happens in every first 12 days of...
  20. T

    Excel VBA date issues

    Hi, I have a user form in which I enter a date via a textbox. The code behind the form stores the dat in a specific cell. Later I read back the date information from this cell and notice that excel gets the date wrong. When I enter the date 6 september 2016 (actually I key in 6-9-2016) the date...

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