PC Review


Reply
Thread Tools Rate Thread

How to determine format?

 
 
Nils Titley
Guest
Posts: n/a
 
      8th Apr 2008
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
 
Reply With Quote
 
 
 
 
Joel
Guest
Posts: n/a
 
      8th Apr 2008
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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:47 PM.