Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date data not viewed as Date?
I have tried some previous posts for other questions somewhat relating to my
situation and they don't work. Is there something uniquely wrong with my data? A customer has imported some data into Excel. They have a column that shows data that looks like a date format: Nov 23 2005 6:47 AM However, the format appears to be General. When they try to format this column to Date Formats, the data does not accept the format change to dates. It just doesn't act like normal data when the Date formats are applied. The formatting list also shows an asterick (*) now. Any suggestions would be greatly appreciated! Jugglertwo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date data not viewed as Date?
Is this perhaps stored as text? General format would not show a date like
this, it would look like 39044.28264. An easy way to fix these, if you've captured the format correctly, would be to select the range of nonconforming dates, search for " 200" (without the quotes) and replace it with ", 200". The comma is enough formatting for Excel to recognize the cell's content as a date rather than gibberish text. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Jugglertwo" wrote in message ... I have tried some previous posts for other questions somewhat relating to my situation and they don't work. Is there something uniquely wrong with my data? A customer has imported some data into Excel. They have a column that shows data that looks like a date format: Nov 23 2005 6:47 AM However, the format appears to be General. When they try to format this column to Date Formats, the data does not accept the format change to dates. It just doesn't act like normal data when the Date formats are applied. The formatting list also shows an asterick (*) now. Any suggestions would be greatly appreciated! Jugglertwo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Extracting data from the current date | Excel Worksheet Functions |