date format

  1. R

    Date Format in table

    Hello Everyone I have a workbook contains multiple sheets having same coloum header B D And G columns are for date .. I want if any one put date under above mentioned columns, it should be in dd-mmm-yy else it should not accept or pop up an error that pls provide date in correct format. I...
  2. E

    Populate userform textbox with date taken from cell in 'dd/MM/yyyy' format

    Hello, I want to fill a userform textbox with a date taken from a cell. The date in the cell is in 'dd/MM/yyyy' but the date drawn from this cell into the textbox comes always as 'MM/dd/yyyy'. Any suggestions would be highly appreciated as I have been wasting tons of hours on that issue...
  3. B

    cannot change date format inside a table

    After creating a sheet of data and running it thru power query/transpose, copying the output to another sheet, sheet still has the data in a table format, and then trying to change the date format it will not work. Using the two methods below, neither one changes the date format. But if I...
  4. P

    dd/mm/yyyy vs mm/dd/yyyy Why is one macro confusing these and not the other macro?

    Hi I know about the classic problem of VBA seeing a date that was in format dd/mm/yyyy and treating it as mm/dd/yyyy instead. But I've developed 2 macros for manipulating different sets of data and I'm puzzled why one of the macros is being affected by this whilst the other macro isn't. Dim...
  5. R

    Pivot table date Format Mismatch

    Dear All I extracted website data for a specified time period from Tool1 & Tool2 and try to compare date wise report between two tools Via Pivot table. But the date format is not matching between the tool even though the date format is same (YYYYMMDD) 20190201. How to sync the dates of...
  6. B

    Converting into date format in excel

    I have selected three cells A1 = Day, B1= Month & C1=Year. Now I want to get date format in cell D1 as DD-MM-YYYY. For example, A1=22, B1=10, C1=1975 and the result will be in D1= 22-10-1975. How can I do that?
  7. O

    Removing a // double slash in a date

    Hi, Back before my time, a program that was written that we no longer have access to the source code wrote dates for some cells with a double slash such as 12//01/2018. I have to go through multiple worksheets in the workbook and manually replace these after the application completes its run...
  8. C

    Require date format - Tried to combine some code but can't get to work

    Hi, I appreciate all the help. Here, I tried to enter the isdate function but can't seem to get it to work. So I took out and need help on how to have a line of code that requires this user to enter date format if the cell is empty. It works to say cell already has data but not to require date...
  9. 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...
  10. 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...
  11. 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...
  12. 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 =...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top