Formatting of column does not continue after session concluded

[lost_in_cyberspace]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have formatted a column for DATE and it records the date as commanded. However, after saving the sheet and then returning to it later the formatting is no longer present for new entries- the format reverts to NUMBER status and I must re-format to have the entry appear as a date.

 

[CyberTaz]

Is Office fully updated (12.1.3)?

It isn't clear exactly what you're saying since it isn't necessary to format
cells for Date unless you want something other than the default short date
formatting to be displayed. Cells with the default General formatting are
automatically reformatted for Date when a date entry is made.

Are you saying that the cells containing dates are formatted *differently*
when you reopen the workbook or that the empty cells you preformatted with
Date formatting don't retain that formatting when you enter content?

Keep in mind that even if you pre-format a cell for Date you still have to
enter it as a date, not just a series of digits.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[lost_in_cyberspace]

Problem is pre-formatted empty cells do not retain the formatting for entered content.
Column was formatted as DATE 3/14 option but when new content is typed in an empty cell the result is as exampled here:
If I type 10/21 the content appears as $.48
If I type 10/21/08 the content appears as $38,280.00

Office was updated today.

 

[CyberTaz]

Is your installation of Office fully updated (12.1.3)? Run Help> Check for
Updates again to be sure, then run Disk Utilities - Repair Disk Permissions
& restart your Mac.

From what you've now indicated it isn't that the Date formatting is
reverting to General (or not "sticking") but is actually changing to
Currency. That should not even be caused by erroneous System Prefs.

Try launching Excel while holding the Shift key. Does it still happen? Is
this happening with all files/sheets or just this one? Is it a new sheet or
are you using some sort of template?

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Guest]

Indeed, my Office update was only 12.1.2. I ran 12.1.3 and now the formatting appears to be working properly.

For what it is worth- it was happening with some sheets but not all even in the same file and it was a file I created not a template.

Thanks you for your advice.