A
Amy
has anyone else had this problem?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Amy,
If a formula in a cell is referencing a date then excel will try and be
helpful and format the answer as a date or if the cell is simply a number and
the cell has previously held a date then once again Excel will try and be
helpful. In either case format as GENERAL or whatever format you want.
--
Mike
When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''s razor (Abbrev)
If a formula in a cell is referencing a date then excel will try and be
helpful and format the answer as a date or if the cell is simply a number and
the cell has previously held a date then once again Excel will try and be
helpful. In either case format as GENERAL or whatever format you want.
--
Mike
When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''s razor (Abbrev)
M
Micael Cervin
Yes, constantly since Excel 2007. Quite a few workbooks has been wrecked due to this bug.
The problem occur when a certain cell format exist and is being set as default (applies automaticly to all cells in the entire workbook).
To solve this, simply delete the actual format. In my case it was [$-41D]MMMM;@
When removed, everything goes back to normal. However, you have to to this on each and every workbook you have. I don?t think there is a general fix (without hard-coding).
/M
The problem occur when a certain cell format exist and is being set as default (applies automaticly to all cells in the entire workbook).
To solve this, simply delete the actual format. In my case it was [$-41D]MMMM;@
When removed, everything goes back to normal. However, you have to to this on each and every workbook you have. I don?t think there is a general fix (without hard-coding).
/M
M
Micael Cervin
Yes, constantly since Excel 2007. Quite a few workbooks has been wrecked due to this bug.
The problem occur when a certain cell format exist and is being set as default (applies automaticly to all cells in the entire workbook).
To solve this, simply delete the actual format. In my case it was [$-41D]MMMM;@
When removed, everything goes back to normal. However, you have to to this on each and every workbook you have. I don?t think there is a general fix (without hard-coding).
/M
The problem occur when a certain cell format exist and is being set as default (applies automaticly to all cells in the entire workbook).
To solve this, simply delete the actual format. In my case it was [$-41D]MMMM;@
When removed, everything goes back to normal. However, you have to to this on each and every workbook you have. I don?t think there is a general fix (without hard-coding).
/M
has anyone else had this problem?
On Thursday, January 14, 2010 3:59 PM Mike H wrote:
Amy,
If a formula in a cell is referencing a date then excel will try and be
helpful and format the answer as a date or if the cell is simply a number and
the cell has previously held a date then once again Excel will try and be
helpful. In either case format as GENERAL or whatever format you want.
--
Mike
When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''s razor (Abbrev)
"Amy" wrote:On Thursday, January 27, 2011 5:46 AM Micael Cervin wrote:
Yes, constantly since Excel 2007. Quite a few workbooks has been wrecked due to this bug.
The problem occur when a certain cell format exist and is being set as default (applies automaticly to all cells in the entire workbook).
To solve this, simply delete the actual format. In my case it was [$-41D]MMMM;@
When removed, everything goes back to normal. However, you have to to this on each and every workbook you have. I don?t think there is a general fix (without hard-coding).
/M