Converting mm/dd/yyyy to mm-dd-yyyy

[pikt11]

Hi everyone,

I've been stumped by this for a while now: when I try to convert a date value form mm/dd/yyyy to mm-dd-yyyy, and output it as a message box, the code works perfectly. However, when I try to put this value into a cell, it reverts back to the original formatting of mm/dd/yyyy. I know this probably has something to do with maybe the default format setup of the worksheet, but I don't know how to fix it.

Thanks in advance, working with dates in VBA has always resulted in a ton of frustration for me

 myfiledate = format(dateresult, "mm-dd-yyyy")
 MsgBox myfiledate
 Range("Z1").Value = myfiledate

 

[Norie]

Either try using DateValue (or CDate) or put dateresult in the cell rather than myfiledate, presuming of course dateresult is a date value.

 Range("Z1").Value = DateValue(myfiledate)

 Range("Z1").Value = dateresult

Now you should have a 'real' date value in the cell and you can format it as you wish.

 

[SpillerBD]

In Excel the Value is the value regardless of format.
If the date is a text string than it is yet to be converted to a value.

Your snippet doesn't really indicate where you are getting "dateresult"
Once you format the cell to display a date (serial number) as "mm-dd-yyyy" it will be displayed as desired.