Skip to Content
0
Former Member
Mar 24, 2009 at 06:24 PM

Problem while concatenating string and Year

15 Views

In my formaulae I am concatenating String and the year

Eg: 'XXX' + ' '+ Cstr(Year(),0)

Output: XXX 2,009

But I want it to be displayed as XXX 2009

Can some one tell me a workaround for this.