Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates displaying as General Data
Im probably doing something wrong, but I dont know what! Im doing this
with a Macro. I have some personnel data, where the date format is mm/dd/yyyy. Name data data 12/31/1939 Name data data 9/30/1941 Etc. In two other columns I select the data based on the month. The date format this time is dd-mmm. Name 30-Sep Name 15-Sep Name 10-Sep Etc. I copy this data to a sort area, using Special Paste, Value. The date format, here, is also dd-mmm. The data is sorted by last name, which puts the blank cells at the top. Then the data is cut and pasted to the top of the Spreadsheet for easy access. The first time I run it, after retrieving the Workbook, the dates display correctly. But if I run it more than once using other months for the selection, some of the dates display as General data rather than as dates. Ive cleared all of the cells, re-established the format, re-created the data, and it still does it. Any suggestions will be greatly appreciated. Tom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates displaying as General Data
You can always have the macro reformat for you. Just do the reformat at the
very end of the macro... "TomD" wrote: Im probably doing something wrong, but I dont know what! Im doing this with a Macro. I have some personnel data, where the date format is mm/dd/yyyy. Name data data 12/31/1939 Name data data 9/30/1941 Etc. In two other columns I select the data based on the month. The date format this time is dd-mmm. Name 30-Sep Name 15-Sep Name 10-Sep Etc. I copy this data to a sort area, using Special Paste, Value. The date format, here, is also dd-mmm. The data is sorted by last name, which puts the blank cells at the top. Then the data is cut and pasted to the top of the Spreadsheet for easy access. The first time I run it, after retrieving the Workbook, the dates display correctly. But if I run it more than once using other months for the selection, some of the dates display as General data rather than as dates. Ive cleared all of the cells, re-established the format, re-created the data, and it still does it. Any suggestions will be greatly appreciated. Tom |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates displaying as General Data
Hi Sean,
I thought about doing that, but I was hoping that it was just something that I was doing wrong. Does this mean that this is a known problem with EXCEL? Tom "Sean Timmons" wrote: You can always have the macro reformat for you. Just do the reformat at the very end of the macro... "TomD" wrote: Im probably doing something wrong, but I dont know what! Im doing this with a Macro. I have some personnel data, where the date format is mm/dd/yyyy. Name data data 12/31/1939 Name data data 9/30/1941 Etc. In two other columns I select the data based on the month. The date format this time is dd-mmm. Name 30-Sep Name 15-Sep Name 10-Sep Etc. I copy this data to a sort area, using Special Paste, Value. The date format, here, is also dd-mmm. The data is sorted by last name, which puts the blank cells at the top. Then the data is cut and pasted to the top of the Spreadsheet for easy access. The first time I run it, after retrieving the Workbook, the dates display correctly. But if I run it more than once using other months for the selection, some of the dates display as General data rather than as dates. Ive cleared all of the cells, re-established the format, re-created the data, and it still does it. Any suggestions will be greatly appreciated. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Displaying single and multiple data series.Single data series | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |