date format

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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