| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format shows on formula bar, 5 digit numbers show in row
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format shows on formula bar, 5 digit numbers show in row
select a cell
click in the formula bar touch ENTER -- Gary''s Student gsnu200709 "CaroleO" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i change the format of a 2 digit date | Setting up and Configuration of Excel | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
| Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
| how to format numbers, digit grouping ,as per regional settings | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Hybrid Mode
