Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ben Ben is offline
external usenet poster
 
Posts: 509
Default convert text to dates

Want to convert text date "30 AUG 2006" to a date. Have used "=DATEVALUE()"
but comes back with #value!.
Would greatly appreciate help here.



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default convert text to dates

Use TTC (Text to Columns).

Select the column, then:
<Data <Text To Columns
And click "Delimited", then <Next <Next

Click on "Date", and make sure that "DMY" shows in the window,
Then <Finish,
And you've got XL recognized dates.

You can now format the data any way you wish.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ben" wrote in message
...
Want to convert text date "30 AUG 2006" to a date. Have used

"=DATEVALUE()"
but comes back with #value!.
Would greatly appreciate help here.




  #3   Report Post  
Posted to microsoft.public.excel.misc
yui yui is offline
external usenet poster
 
Posts: 4
Default convert text to dates

Hi,
If you have the text date "30 AUG 2006" in cell A1. you can use
=datevalue(a1) or =datevalue("30 AUG 2006"). if the answer return in number
like 38959 you can format it. (if you use =datevalue("a1") it will answer
#value!.)
yui

"Ben" เขียน:

Want to convert text date "30 AUG 2006" to a date. Have used "=DATEVALUE()"
but comes back with #value!.
Would greatly appreciate help here.



Reply
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
Dates formatted as text thekovinc Excel Discussion (Misc queries) 5 February 14th 06 07:49 PM
imported text data converting to dates ajd Excel Discussion (Misc queries) 2 December 21st 05 07:48 PM
Convert text to numbers vipa2000 Excel Worksheet Functions 3 August 1st 05 09:01 PM
convert value stored as text to logical refrence value! Remote Desktop Connection hotkey Excel Worksheet Functions 2 August 1st 05 01:56 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 10:25 PM


All times are GMT +1. The time now is 12:23 AM.

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

About Us

"It's about Microsoft Excel"