date format change

  1. N

    Change date format in cell when using excel date addin

    I found this excel addin, and I need to change the date format and locale, but when I use numberformat in the cell, the date format doesn't change: Excel date addin This si the code I am using: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then...
  2. P

    Date format issue - dd/mm/yyyy

    Hi! I am desperate. I purposely registered just to ask this question. Hope you can help. I have a shared file in server. I change all date values to dd/mm/yyyy format. But every time another user opens it, the format becomes d/m/yyyy. I prefer dd/mm/yyyy so all numbers are aligned. How do I...
  3. divster27

    Returning a date format in a formula as date format (currently showing as text)

    I have a simple formula that looks at cells to return a string of data - release date , Artist, Title Release date is in column M, Artist in column B, title in column C i want to come back with the following data Release date = 12/03/2021 - Black Crowes - Southern Harmony my formula looks...
  4. D

    Removing hidden formatting - VBA substitute for double-click (Text to Columns not working?)

    Hi Folks, I have an excel report that has been exported from a website. The date column has some hidden formatting on it, so that when I format the column using: Range("RepTable[Delivery Date]").Select Selection.NumberFormat = "yyyymmdd" The date remains in the format: DD/MM/YYYY. When I...
  5. 2

    Date format

    Hello Friends, Is there a way for me to change date format from 'day/month/year' to 'month/day/year'? Sample data in my file is as following: Current value: 2/12/2019 Intended value: 12/2/2019 There are about 300 values in the column. Regards, Rajesh
  6. 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...
  7. J

    Date Swapping Formula

    Hey Guys/Gals, I have been using a date swap formula to basically swap the month and day between "/" slashes. =IF(ISTEXT(C7),DATE(RIGHT(C7,4),LEFT(C7,SEARCH("/",C7)-1),MID(C7,SEARCH("/",C7)+1,2)),DATEVALUE(TEXT(C7,"mm/dd/yyyy"))) I originally was working on the formula for sample dates such...
  8. C

    Change of date format

    Hi everyone, I'm having a trouble of changing a table of date format. I have a list of mix date format of dd/mm/yy and mm/dd/yy, is there any formula I could use to change the format to mm/dd/yy at once? Thanks in advance! -Cass
  9. K

    Unable to change Date format

    Hello, I have this stupid problem where I cannot change the date formatting. Can someone help me. I'm going crazy...:rofl::rofl::rofl: I check in google to see if I can solved my problem. I could see a lot of people has a trouble change date format but it doesn't solved mine. Here is what I...
  10. V

    Date format conversion

    Hi, As per attached file can you please let me know how i can change format of below date. "Feb 3 2016 5:44PM " Thanks in Advance
  11. D

    How to maintain dateformat as d/m/yyyy in csv file before copying to another workbook?

    Dear Excel Experts, Currently, I'm using a vba script to copy content in every sheet1 in csv file into the new worksheet tab next to Sheet1 in master workbook. It supposed to compile all csv file content into one master workbook. However, I notice that those dates format will automatically...
  12. MrManBoy

    Convert text date to date format

    Hi Team, How does one change a text date to a excel date format? I tried simply by formatting the cell to date format, yet still not working for me. :confused: https://drive.google.com/open?id=0B-TPXFo_aWFqazc0Q3QySUl1RWM
  13. J

    Converting text into a date using Vlookup

    I am attempting to extract a date from a cell that is in string format using a particular VLOOKUP. This is the VLOOPUP statement (it works!) Target.Offset(0, 20) = Evaluate("=VLOOKUP(" & Chr(34) & Target.Value & Chr(34) & ",'[Volume Alerts.xlsm] Data'!$A:$W,20,FALSE)") The date is showing in...
  14. S

    date format changes while transferring data to excel sheet from userform

    Hi everyone... in a userform textbox if i enter a date format dd/mm/yy and transfer to excel sheet, it saves as mm/dd/yy. Kindly help. I need to save the data as origin i.e. dd/mm/yy. Thanks.
  15. J

    Different Date Formats

    Dear Excel Geniuses Hi I have 20K+ rows containing different date formats. I need your help to convert in single format ie. UK/US. Regards Jewnaa
  16. H

    Date format chaging when copying sheet from another workbook

    Hi, (its nice to see mrexcel forum still active. last time I used it was in 2002 ! ) I am trying to open a different workbook and copy one of sheets data to current sheet. It works, but date stored as "1/11/2013" is chaging to "11/1/2013". (if the date is "23/9/2013", its getting copied...
  17. J

    Textbox to Cell not copying as date

    Hi I have a column of data that contain dates. The values are DD/MM/YYYY but the cell format is set to "ddd dd mmm yy" to display the date in the required way for the entire column (e.g. 01/05/2012 becomes Tue 01 May 12). I have a userform with a textbox that displays one of the dates in this...
  18. F

    VBA: Find column header and reformat (date) values in columns

    I have VBA code to perform some actions on data in excel file and then convert all that data into semi-colon separated CSV/text file (code below). Now, all I want is to add VBA code in the existing macro to find a column header (say, "Application date") and then convert all the dates...
  19. S

    Date Being Pasted USA Style When I Want UK Style From Input Box- Excel 2007

    I'm using an input box in a do loop to ask for a date to be input UK style in the format DD/MM/YYYY. I have the cell where it will be pasted to formated as Date Type *14/03/2001. However when say, 11/02/2013 is typed into the input box, 02/11/2013 is pasted into the required cell. the loop I am...
  20. M

    Date formatting question

    I have a cell that references another cell with a date. This is how it is referenced: "&'Source Deed'!B11&" dated "&'Source Deed'!B9&", from "&'Source Deed'!B3&", Grantor(s), to "&'Source Deed'!B6&", Grantee(s), recorded in Volume "&'Source Deed'!B12&" I cannot figure out how to get the...

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