Variant data types

Hi,

Im getting the error below in the image with my SWITCH statement. Is there a way around this?

I think it might be by using the FORMAT function, but I'm not quite sure where.

Thanks in advance

Liam