OFC 07 wrkbk saved short date format changes to general when reop

R

Roberta

We have a shared workbook that is saved in 03 format although we are using
Office 2007. We have two columns that are formatted as short date, then
saved. However upon reopening it reverts to General. What is the problem?
We highlight colum and choose short date, then save in 03 format.

We save in 03 format b/c one person has not upgraded to Office 07.

Please give feedback.
 

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

Similar Threads

Auto Cell Format Change from General to Custom Date 1
Format General date format into short date when exporting 1
Default Date Format 0
Page Size Reverts to Letter when Set for Tabloid 3
check date format in regional setting 2
Large Workbook - trouble opening 5
how to generate date format "YYYY Q" 4
changing date formatted as general number into date format 4

Top