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

 
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
HOW DO I CONVERT XLSX FILES BACK TO EXCEL 2003? vei Excel Discussion (Misc queries) 5 July 10th 06 09:28 PM
editing an excel 97 file within excel 2003 and saving back as exce Chris Egebrecht Excel Discussion (Misc queries) 3 March 24th 06 11:14 PM
Can I transfer files back & forth from excel 2000 to excel 2003? pheller Excel Discussion (Misc queries) 1 June 30th 05 06:26 PM
How do I get "tools" back into the menu in 2003 Excel? Fred Excel Discussion (Misc queries) 4 June 17th 05 09:29 PM
How can I batch open a txt file in excel 2003 and save back as a . P Silzle Excel Discussion (Misc queries) 3 February 9th 05 11:44 PM


All times are GMT +1. The time now is 06:57 AM.

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"