Search : in
By :

Convert a numeric string to date, month, year

Last answer on Oct 27, 2009 1:43:41 am GMT pablo, on Oct 26, 2009 7:20:40 pm GMT 
 Report this message to moderators

Hello,

I downloaded a file that contains a numeric string such as >>> 20091020120000[0:GMT]

How do I change this display to read 10/20/2009?

i am using excel 2007 but will use earlier version if needed.

Configuration: Windows XP
Firefox 3.5.3

Best answers for « convert a numeric string to date, month, year » in :
How to convert a numeric value into english Word? ShowHow to convert a numeric value into english Word? To convert a numeric value into eng. Word, here is the formula you will need This is a post from the forum, thanks to rajput391 Below code enter in excel sheet: 1. Press Alt+F11 >...
Mktime() - Timestamp yesterday, last month, etc.). ShowMktime() - Timestamp yesterday, last month, etc.) Intro Last 24 hours Yesterday This week Last week This Month Last 30 days (last 30 days) Last month Current year(this year) Last year (last year) Intro The mktime()function...
[PHP]Last day of the month/Number of days in the month ShowLast day of the month and number of days in a month Using $m as the number of the month i and $y as year. Function date() can display directly the number of days in the month using the "t" character:
Download Streamripper ShowThere are numerous streaming audio files on the Internet. Then record this music diffused non- stop music. Streamripper allows the recording of the audio streams on Internet. It manages several types of stream: - Shoutcast MP3 streams, all the...
Download MDB2SQL Data Migration ShowMDB2SQL is a converter application to convert your access database to SQL Server without changing or writing the line of code. Advantage It can convert all your databases, in Access (.mdb) in a very fast and effective way and can even allow you to...

1

 venkat1926, on Oct 27, 2009 1:43:41 am GMT

Suppose the entry is in A1


=(MID(A1,5,2)&"/"&MID(A1,7,2)&"/"&LEFT(A1,4))+0

if necessary format this to a date

Reply to venkat1926