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: 354
Default How to auto convert text to date format

I have two computer. One is Excel 2000 and other is Excel 2003. And these two
computers are same regional and time setting.

When I try to open a website in these two computers, I found that there has
a big problem here.

For example,
In Excel 2000, it will auto convert text like "1 Apr 2008" to my computer
default date format "m/d/yyyy = 4/1/2008".In Excel 2003, it cannot do this
automation.

Because I have many vba programs are based on the default date format
"m/d/yyyy", which make me very inconvenience.

Thank you very much!

Daniel
 
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
Convert Text to Date format Fellow Wanderer Excel Discussion (Misc queries) 3 October 4th 07 08:49 PM
Convert date + time text format to date format Paul Ho Excel Worksheet Functions 2 May 22nd 07 05:47 PM
How to convert text into date format? Eric Excel Discussion (Misc queries) 6 January 24th 07 03:27 PM
How to convert text into date format? Eric Excel Worksheet Functions 4 January 24th 07 02:37 PM
Help: How do I convert a text date into a real date format japorms Excel Worksheet Functions 4 August 2nd 06 06:36 PM


All times are GMT +1. The time now is 12:36 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"