Date format shows on formula bar, 5 digit numbers show in row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2003, SP1

I am copying the date column from one worksheet to another within a
workbook. If I paste or paste special values, the new date row shows a 5
digit number(36069), but the date in the formula bar shows MM/DD/YYYY
(12/18/2006) which is the date format I am copying. I have formatted the
receiving column to date before and after the paste - no change. The Tools,
Options, Calculation, Date System is unchecked in both sheets.

TIA,
CaroleO
 

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

Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? 2
Excel 2002: How to make the date format uniform ? 1
Formatting Dates from Text to Numbers 2
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
Formatting Text to Numbers for Dates 2
Excel Issue with "Average" showing in Status Bar 2
Remove date format? 3
Date Format 2

Back
Top