How to determine format?

  • Thread starter Thread starter Nils Titley
  • Start date Start date
N

Nils Titley

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
 
A cell format general will return general as the number format

If Range("B1").NumberFormat = "General" Then
z = 1
Else
z = 2
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing dates 1
Compare dates 2
Excel is changing date format incorrectly 7
International Date formatting 4
Data Problem 8
Date Formats 3
Date format error with CSV file 6
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top