You probably know that the underlying values are the same no matter what,
right. Well, select the values you want to format, Right Click Format
Cells Number choose the appropriate Format there...

This is worth a look, when you have some free time:
http://www.cpearson.com/excel/datetime.htm

Take a look at this too:
http://www.contextures.com/xlfaqPivot.html#FormatLost

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"DaveL" wrote:

My programs creates a new sheet for a pivot table but my numbers are being
changed to dates. Where do I look to see what is causing this, or to stop it?

Thanks