Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Back to basics of excel 2003
Having a limited memory, please help me to recall the solution
i have cell values below in a column of *text dates* <m/d/yyyy '5/5/2008 '3/19/2008 '5/6/2008 '4/12/2008 '3/26/2008 '12/28/2008 problem is - it was imported and i need them to be reckognized as real date values by xls 03. The * ' * is quite hard for me to recall of how i can clean them. -- regards, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Back to basics of excel 2003
Perhaps like this:
=RIGHT(A1,LEN(A1)-1)*1 with your date in A1 - format the cell as a date, then copy down as required. You could also try Data | Text to Columns. Hope this helps. Pete On Apr 28, 1:30*pm, driller wrote: Having a limited memory, please help me to recall the solution i have cell values below in a column of *text dates* <m/d/yyyy '5/5/2008 '3/19/2008 '5/6/2008 '4/12/2008 '3/26/2008 '12/28/2008 problem is - it was imported and i need them to be reckognized as real date values by xls 03. *The * ' * is quite hard for me to recall of how i can clean them. -- regards, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Back to basics of excel 2003
Data (menu) | Text to Columns
will work. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "driller" wrote in message Having a limited memory, please help me to recall the solution i have cell values below in a column of *text dates* <m/d/yyyy '5/5/2008 '3/19/2008 '5/6/2008 '4/12/2008 '3/26/2008 '12/28/2008 problem is - it was imported and i need them to be reckognized as real date values by xls 03. The * ' * is quite hard for me to recall of how i can clean them. -- regards, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Back to basics of excel 2003
thanks again to Pete and Jim.
-- regards, "Pete_UK" wrote: Perhaps like this: =RIGHT(A1,LEN(A1)-1)*1 with your date in A1 - format the cell as a date, then copy down as required. You could also try Data | Text to Columns. Hope this helps. Pete On Apr 28, 1:30 pm, driller wrote: Having a limited memory, please help me to recall the solution i have cell values below in a column of *text dates* <m/d/yyyy '5/5/2008 '3/19/2008 '5/6/2008 '4/12/2008 '3/26/2008 '12/28/2008 problem is - it was imported and i need them to be reckognized as real date values by xls 03. The * ' * is quite hard for me to recall of how i can clean them. -- regards, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Back to basics of excel 2003
You're welcome.
Pete On Apr 28, 2:02*pm, driller wrote: thanks again to Pete and Jim. -- regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I CONVERT XLSX FILES BACK TO EXCEL 2003? | Excel Discussion (Misc queries) | |||
editing an excel 97 file within excel 2003 and saving back as exce | Excel Discussion (Misc queries) | |||
Can I transfer files back & forth from excel 2000 to excel 2003? | Excel Discussion (Misc queries) | |||
How do I get "tools" back into the menu in 2003 Excel? | Excel Discussion (Misc queries) | |||
How can I batch open a txt file in excel 2003 and save back as a . | Excel Discussion (Misc queries) |