| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting values which are in Numeric format to word format | Excel Discussion (Misc queries) | |||
| reset charting default format within a workbook | Excel Worksheet Functions | |||
| How to set default number format for new workbook | Excel Discussion (Misc queries) | |||
| Default numeric value | Excel Discussion (Misc queries) | |||
| Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
Hybrid Mode
