Dates are stored in excel as a number with 1 = Jan 1, 1900. Every day
increments by 1 so Jan 2, 1900 is 2. An hour is stored as 1/24 and a
minute is stored a 1/(24*60) with midnight equa 0. So noon is equal to
1/2 (.5) and 6:00AM equals 1/4 (.25).

Formating a date doesn't change the whay it is stored into the
spreadsheet. A date is stored as the number equivant. Tformating only
change the way the date iis displayed.

My guess is this is not an excel problem. since you are copying form
text boxes the date goes into the clipboard. So there is a problem
either going from the text box to the clip board or from the clip board
into excel.

You could try opening up Notepad and see what happens if you copy a
date from excel into Notepad and from Notepad to excel. This may help
isolate the problem. You can also view the clip board data by opening
up the TaskPane from the worksheet view menu and then pressing the down
arrow in the View Pane and select ClipBoard.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=169184

Microsoft Office Help