dateformat

  1. B

    excel vba date format into short date

    Can someone help me on this please.. I'm try to run the following script however it is getting failed at line (lo.ListColumns("Final Status").DataBodyRange.Value = Result 'write array to listobject) The reason is becoz of Date format. It works perfectly when I change the column date...
  2. J

    outlook zip file

    Hi, have this code to just down load zip file but it's downloading all, do i need to change something in the code i created a rule to subject only Weekly AP but is downloading everything. here is the code:Public Sub saveAttachtoDisk(itm As Outlook.MailItem)Dim objAtt As Outlook.Attachment Dim...
  3. D

    Excel VBA Date in wrong format

    I need to export data from a excel file to a CSV file (to use for import in MailChimp) using VBA. I have dates in columns and in excel (* .xlsm) dates are correct, but after they are copied to * .CSV and I open the * CSV file again, some dates are not correct. I have checked that all cells in...
  4. M

    Outlook VBA to save a file attachment locally

    Hello, hoping someone can help me with the following - I get an email every day with an attachment I have to save down on my hard drive to build a report. Trying to automate this process, and looking online, it seems I can use something like the following code, but in those instances it seemed...
  5. M

    Add date in blank cells using vba

    I currently use the following code to add the date "31/12/9998" in blank cells of column F. The problem I have is after running the code, my filters are now on a "A to Z" rather than "Newest to oldest". How do I go about formatting the column in order to be able to sort by Newest to Oldest...
  6. V

    Missing date format after refresh pivot table

    Hi, When I refresh a Pivot Table trough VBA, the horizontal axis date format changes. It has to be dd/mm/yyyy, but automatically changes to U.S. date format mm/dd/yyyy. If I refresh the table manually in excel works fine and the format doesn't change. I've searched trough this forum, google...
  7. G

    How to set language for date time formatting in TEXT()

    Hi, I'm running Excel 2010 English on a Windows 7 - Swedish (not English). In Excel I have created a sheet full of calculations using the TEXT() function. Suddenly (perhaps due to Win7 upgrade) my Excel doesnt understand =TEXT(A1;"yyyy") anymore, it wants the date format in Swedish codes...
  8. B

    Date format 8/8/08 (m/m/yyyy) to dd/mm/yyy

    Hi Guys, I have imported some raw unformatted data into in excel and the date comes in as eg 8/8/08, 6/12/08, 12/9/08 in the US format. When I do a date format on it 6/12/08 could be 6th Jan 2008 instead of 12 Dec 2008 etc.. Is there a way of acurately formatting as dd/mm/yyyy? Thanks

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