Peculiar default cell format


W

Walter Briscoe

I use Excel 2003.
I have a workbook sent to me, but can't consult the author.
I want to construct a pivot table.

My basic table comes out as:

A B
1 Drop Page Fields Here
2
3 Sum of MZone Total
4 Total 00:00:00

[B4] presents as 00:00:00 because its format is Time.
I might expect the default format to be General.
I don't expect it to be time.
In the fx formula field, [B4] presents as 23/01/1906 00:00:00.
If I change the format to General, [B4] presents as 2215.
I guess 23/01/1906 is 2315 days after date 0.

What should I look at in the data?
On the data sheet, the "default" cell format is also time.
Occupied cells format is General.
 
Ad

Advertisements

W

Walter Briscoe

In message <[email protected]> of Thu, 22 Aug 2013
17:29:34 in microsoft.public.excel.worksheet.functions, Walter Briscoe
I use Excel 2003.
I have a workbook sent to me, but can't consult the author.
I want to construct a pivot table.

My basic table comes out as:

A B
1 Drop Page Fields Here
2
3 Sum of MZone Total
4 Total 00:00:00

[B4] presents as 00:00:00 because its format is Time.
I might expect the default format to be General.
I don't expect it to be time.
In the fx formula field, [B4] presents as 23/01/1906 00:00:00.
If I change the format to General, [B4] presents as 2215.
I guess 23/01/1906 is 2315 days after date 0.

What should I look at in the data?
On the data sheet, the "default" cell format is also time.
Occupied cells format is General.

I DO apologise for not looking hard enough to find an answer.
Format Style has Number set to [$F-400]hh:mm:ss AM/PM.
I can set that to a more sensible value.
 

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

Top