Peculiar default cell format

  • Thread starter Thread starter Walter Briscoe
  • Start date Start date
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.
 
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.
Click to expand...

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.
 
Back
Top