How to determine format?

's Computer Specifications

In a CSV file, the dates can be formatted in General or Date format. I need
to be able to determine what the date format is.

It also appears that sort treats General and Date formats differently. Why
is that?

Thanks

's Computer Specifications

A cell format general will return general as the number format

If Range("B1").NumberFormat = "General" Then
z = 1
Else
z = 2
End If

"Nils Titley" wrote:

> In a CSV file, the dates can be formatted in General or Date format. I need
> to be able to determine what the date format is.
>
> It also appears that sort treats General and Date formats differently. Why
> is that?
>
>
> Thanks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determine day of week in text format	WLMPilot	Microsoft Excel Misc	6	6th Oct 2008 03:13 PM
URI Format exception. Unable to determine URI Format	Bob	Microsoft C# .NET	1	13th Mar 2006 10:23 AM
How to determine if a xml is well-format	ad	Microsoft C# .NET	1	31st May 2005 08:39 AM
How to determine cell format in different locals	=?Utf-8?B?Z29MZWFmcw==?=	Microsoft Excel Misc	1	23rd Jul 2004 09:43 PM
How to determine BOLD cell format.,...	Rick Norris	Microsoft Excel Worksheet Functions	2	30th Sep 2003 08:33 PM