How to Write dd/mm/yyyy as Text (March-13)

[hjames]

Hi Peeps

Having some trouble getting my VBA code to write "March-13" as text, rather than 01/03/2013

Can anyone suggest some code that will make it write it as the text, "March-13"

My current code is:

Cells(emptyRow, 1).Value = VarMonth

where, VarMonth is a cell on the sheet with, "March-13" written in it

Many thanks for your help!

[zbor]

Try

Format(variable, "mmmm-yy")

[hjames]

Hi zbor

That does work, however, when I click on the cell, it shows as dd/mm/yyyy - which means when I use it in a pivot table, it appears as 01/03/2013 rather than how it looks on the sheet as "March-13"

hope that makes sense?