I regularly use an Excel spreadsheet with a column of minutes & seconds
entries, fomatted using =TIME(h,m,s). The cell's number formatting is set
for mm:ss and it displays properly. However, if I make any change at all to
the cell's contents, the number formatting resets and the display turns to
time of day. This surely cannot be a feature of Excel, but rather an error
in which the cell's formatting is overridden by an incorrect assumption.
Is there any way to keep the previously selected time format when I change
cell data?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I'm not 100% sure what you mean, but this is what I think could be the
problem.

If you format a cell mm:ss it is only the display of the data that is
mm:ss, not the data itself. The data is stored in date format
(something like 38888.32432532434). You can't just enter minutes and
seconds and ignore the date and hours.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553495