View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Jagxke Jagxke is offline
external usenet poster
 
Posts: 1
Default How do I set the default format in a workbook to numeric?

When I click a value in a PIVOT table, the workbook that comes up defaults to
date values for all numeric cells. How can I change the default to numeric?
I know how to change it manually but shouldn't have to go through this stem.

This is a MS 2007 Excel question.

Any help would be greatly appreciated.