LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
DHT
 
Posts: n/a
Default How do I maintain my date format, when I copy a sheet, in excel?

I have created a document with several sheets, tracking video tapes and their
content, as well as date the tape was shot, etc. As projects are completed I
am saving the sheet as its own book and removing it from my original file.
I've done this to several sheets and each one, when I open the newly saved
file, screws up my dates and reverts to some date 4 years ago, and not even
the same day of the month. I ran into this problem a few years ago in a
similar circumstance. Can I save my document, or have I lost my original
date information? The orginal document is maintaining the correct dates.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Date Format - users should be able to override it automatic. jamezog Excel Discussion (Misc queries) 7 May 20th 10 02:45 PM
Opening a csv file with US date format on a Australian PC Troy Lea Excel Discussion (Misc queries) 2 March 16th 05 10:05 PM
Date Format Question Josh O. Excel Discussion (Misc queries) 1 February 10th 05 09:45 PM
Format cells as date bay Excel Discussion (Misc queries) 3 January 26th 05 05:34 PM
Excel Date Format - Stop? Bob Excel Worksheet Functions 4 January 11th 05 01:11 AM


All times are GMT +1. The time now is 08:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"