Column format in pivot table

Please post an xlsx file, since you use Excel 2007.

See the formula is I till M.

I2=A2*1
J2=YEAR(I2)
K2=MONTH(I2)
L2=DAY($I2)
M2=WEEKNUMBER($I2)

And format the month, day and week on 00.

After that a pivot table.

See the attached file.

you mean the values in the pivot table with currency?

so on sheet foglio1?

if so (#7) see the attachment.

@max_max

See #8.

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

when you make a pivot table, you see on the right side 4 boxes.

in the box Value I put the column with the values.

Click twice in the valuebox on the text som van Value (sum of Value).

Format Value (last option).

Value format (on the left side, below in the new pop up).

Choose currency (3rth option).

Hope I explained well enough.

Thanks for the rep.

You're welcome. We appreciate the feedback!

Thanks for marking the question solved.