date format issue

  1. D

    Timestamp reads as text when converting to Date

    Hello, I have been trying different ways to create a Date on this timestamp which usually involves me using a DATEVALUE+TEXT combination which generally works and converting the timestamp field to General (currently is set to Date when just the raw file). However, no matter how I split the...
  2. B

    Formatting date problem

    I am trying to extract a date from a text string and write it to another column is a spreadsheet. The date is in the input string in col A and I want to extract this date and write it to col F in the format dd/mm/yy. In the code below, at the line Cells(c, "f").Value = str1, str1 shows the...
  3. E

    Why do some numerical dates pull and format correctly and others as zero (0)?

    Problem: My formula to lookup (using INDEX / MATCH) to pull in date values from one workbook to another appears to be working correctly, but some dates just pull in and convert to zero and I'm not sure why? What I'm trying to do: Is save time rather than copy manually all these over. The...
  4. M

    Date format does not correct from third party program

    Hello guys, I got date format from third party program like in the below pictures. 2023 = years 03 = month 22 = date 01 = hours time 13 = minute 50 = secs I have tried to change date format to Short format, Custom format. But it always show like in the Cell A1. Could you help me to change...
  5. 0

    Problem with Dates being "read" based on different languages in computer

    Hi, guys. I have built a spreadsheet to control rotation of crews but for some reason it is behaving oddly depending on the computer it is opened. Whenever I open it in a computer with laguange set in Portuguese the flights are not returning the pax list unless I have to change the date format...
  6. A

    Recognizing output as date

    I'm getting outputs from an auto-generating report in the following format. Excel recognizes it as "General" and I'm struggling to convert it to a recognizable date format. Don't care about the time stamp (MM/DD/YYYY would work). Any help is really appreciated! Mar 01 2020 00:00:00 Apr 19...
  7. S

    Date Conversion problem

    Hi All, I have a huge list of dates that I need to sort based on the month. However, I am unable to format some of the dates, no matter whatever format I chose in Excel. Below, I have provided a sample of the list which contains four dates. The first two can be easily formatted, but the last...
  8. 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...
  9. F

    combo box (form control) returns wrong date

    Hi I have a list of dates in E5 to E7, in long date format. I have a form control with an input range of E5 to E7. The cell M5 also has long date format and is the cell link for the format control. Cell M5 does not display the correct dates from the dropdown list and instead displays 1,2 or...
  10. X

    Date format excel

    Hello, I have created a userform that will allow users to input multiple lines of data into a table based on a selection in a list box. The userform consists of some textboxes and a listbox (multiple selection). I have a problem with the textbox where i have to insert date. The problem is that...
  11. 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...
  12. S

    Excel VBA: Couintif not working, seems to be a problem with date formatting

    I'm trying to count how many times the same Date is repeated in a range. This is what I have so far, and is not working. Sub counting() <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height...
  13. P

    Excel date format issue

    Hi everyone, how are youyou doing? My problem is that I Have a colums "C" With data of the type 1.12.17 I want to change these data to the date format 01/12/17 (dd/mm/yy) I use a VBA code to replace all the dots with "/" The code looks like this: Sub ReplaceDots() Dim i, k As String i = "." k...
  14. E

    Insert characters in a cell

    I have a cell that lists the date as example 11/3/17 i would like to have it list as 11/3/2017 so I can format as a date showing November 3, 2017. Can not do with 2 characters in year field. Any help greatly appreciated. Thank you
  15. B

    Date format in cell does not match date format in formula bar

    Please help. I'm having trouble getting the date format in the formula bar to match the date format in the cells of my worksheet. I have my dates formatted in my cells as m/dd/yy however the formula bar shows m/dd/yyyy. I'm trying to get the formula bar to return only the 2 digit year format I...
  16. M

    Date formatting issues

    Hi Guys, Simple fix i hope, but this has been driving me nuts for a couple of day now. I made a CRM system to use for work, and have recently been provided with a mac laptop. when i open the crime file, it seems to have changed all of my dates to US format MMDDYYYY. i can simply change these...
  17. E

    Date format issue when using Forms

    I have a user form which has some textboxes on it which the user fills in information which is then entered into a spreadsheet. 2 of these textboxes are used to input dates however I have noticed an issue which I have never noticed before. When a date is entered in the format dd/mm/yyyy, if the...
  18. S

    Need help adjusting VBA to change date formats in text.

    I am currently using the macro illustrated below, which has been working perfectly fine for a long time. The only problem I'm currently encountering is whenever it is processing data that contains text within sentences and paragraphs, it always changes whatever the current dating format is to...

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