I don't quite understand but if you just want to format your date as Sep
mmm

"PEdro" wrote in message
...
Hi

I have in cell A1 the value 31/09/2003
This is formatted has mmmm/yyyy
So the result is "September 2003"

What code should I write in order for getting the variable
strMon with the
first 3 caracters of September "Sep"

Thanks
Pedro