Custom NumberFormat VBA

[jongooligan]

I've inherited this bit of code

Range("B12:C600").NumberFormat = "dd/mm/yyyy;@"

Thought "@" was a text placeholder but the life of me I can't see what the ";@" bit is doing. Any ideas?

 

[Andrew Poulsom]

You're right, it's superfluous.

 

[jongooligan]

Thanks Andrew.