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

J

Jagxke

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.
 
K

Khoshravan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
How do I link a cell in a workbook? 1
How do I set focus (and select text) on a text box on a modeless userform? 0
How to add day to PWA 2016 date format? 0
How do I set the default numeric format in Excel 2007 (XP)? 1
Problem with SET & REF function 0
Peculiar default cell format 1
New computer, how do i move outlook 365 ENTIRELY? 0

Top