What do you mean it's "not working" in Excel 2003?

MsgBox Format(Date, "YYYYMMDD")

produces a message box with the string "20040916" for me.

What do you get?

In article ,
"JV" wrote:

I have VB code in Excel Spread sheet that uses Format function to convert
date to yyyymmdd format, it works in Excel 2000 but not in Excel 2003. Any
info on replacement function?