LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Vlookup to Return a Range of Data James Excel Discussion (Misc queries) 0 July 13th 06 09:44 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Extracting data from the current date Cali00 Excel Worksheet Functions 2 April 14th 05 05:49 AM


All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"