convert date text

  1. S

    Converting date as string to a number using VBA

    Many thanks in advance for your time and help . . . I have a simple user form where the date of an office visit is entered (as mm/dd/yy in OVDateTextBox) and the difference between that date and today's date is calculated. I am trying to build in protection against user entry errors where a...
    • seleseped
    • Thread
    • convert date text convert date to number text string vba
    • Replies: 6
    • Forum: Excel Questions
  2. J

    Convert Text 01.03.2015 to Date 03/01/2015

    Hello All -- I receive a daily file with dates formated as "general" with DD.MM.YYYY, but want to see MM/DD/YYYY Ultimately, I am trying to Convert Text 01.03.2015 to Date 03/01/2015. I tried to format cells as "date" but unsuccessful. I also tried other things like replace all . with / ...
  3. S

    Help with imported data from ERP system - issues with leading zeros, text to date

    I just started at a new company and am having issues using the information I have pulled from our ERP system (SyteLine, which uses a SQL back end) into excel. The problem is the formatting of our sku's... there is no common part number format across all of our product lines. Some start...
    • schbrownie
    • Thread
    • convert date text leading zero leading zeros leading zeros in number text to date
    • Replies: 1
    • Forum: Excel Questions
  4. R

    Convert Number (YYMMDD) to the actual date indicated.

    Down loading data I receive dates as a number that indicates YYMMDD (ex. 130603 is 03 JUN 13). Is there an easy way to convert these number strings to the actual date indicated other than typing it in?
  5. G

    Cnverting text date into Excell date

    Hi, I have a cell filled with date in a text format like "May 8 2011" or "Jun 6 2008" and need to convert them into excel cell date format such as "05/08/11" or "06/06/08". Unfortunately the lookup function work only for data sorted in ascending order. Thanks in advance for your help.
  6. T

    Convert dates mm/dd/yyyy to TEXT mmyyyy

    Hi, I have a date column formatted mm/dd/yyyy which needs to be converted to mmyyyy in TEXT format. I can change date format to mmyyyy, but when I attempt to convert to text it reverts back to original date format of mm/dd/yyyy. Any suggestions? Many thanks, TC

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