Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
i am able to load =round(WEEKNUMBER) & 'WK' and come out '1WK'. But may i know how to make 'WK' in the beginning like WK1?
1WK 2WK 3WK 4WK
become
WK1 WK2 WK3 WK4
in pivot table
Thks a lot
Sounds like ='WK' & round(WEEKNUMBER)
Thank you Or. It works. I tried this before but the result was not same this time. thks anyway.