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.

How do I set the default format in a workbook to numeric?
 

First, select all cells you want to apply this format.
Go to Format| cell| Number tab, under category list select proper item
(Number). If a lsit appear on the right, select the desired one. HTH
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Jagxke" wrote:

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.