BO4 - Object format applied in IDT tool not working

Hi

Using BO4 SP6 adn have numeric columns (6 digits in length).

Year and week

Showing in reports as 201,312 rather than 201312.

Tried custome format in universe as ###### and 123456 and 999999.

However when report runs doesn't apply the mask

i.e instead of showing as 201312 as we want shows as 123456 or 999999 or ######

Anybody know how to solve this?

Thanks

Philip