m/d/yyyy

  1. J

    Change my sheets

    Trying a little humor with the subject. :) I recorded the following macro in excel, then shortened/simplified it. If I am in Developer Mode and run it from there, it works great, but.. I am trying to assign the code to a button. When I do and click the button, it appears to be running on...
    • juneau730
    • Thread
    • button lookat=xlpart m/d/yyyy replacement= selection.numberformat
    • Replies: 11
    • Forum: Excel Questions
  2. B

    Date value in VBA appears as mm/dd/yyyy instead of the actual format which is mm-dd-yyyy

    Hi, I can't get my my date to display in the format that I want it to as a string variable in vba. Public Sub Todaydate() Today = Sheets("Date").Range("B1").Value MsgBox Today End Sub The msgbox displays 3/21/2017 The value in B1 shows as 3-21-2017 I want the variable "Today" to...
    • bellg
    • Thread
    • date format m/d/yyyy mm/dd/yyyy string
    • Replies: 3
    • Forum: Excel Questions

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