Is there a way to check what format a cell is set to or the data is set to?

Right now the correct cells or data are set to General. If I know that the
cell or data was set to date format, I could convert the data only those
dates.

I am not sure we are going to be able to get the data converted on a regular
basis. Many people are using the data that is generated by the third party.
Though I realize that is the best way.

Thanks for your help.


"Net_prof" wrote:

Unless there is some other indicator in the record to help you determine when
the use what format, you will continue to experience this problem.

You need to work with the source to identify the problem and involve them in
the solution. Without their help, this is why you are continuing to
experience the problem. I've worked with a lot of EDI where this is also an
issue. The old adage, "garbage in, garbage out" pertains here without both
sides working towards fixing the problem.





"Nils Titley" wrote:

I tried getting help with this before and did not get it resolved.

Here is the problem. I am processing data files in a .CSV format. These
files are processed in South Africa where they use the date format:
dd/mm/yyyy. When I process the file if the dates are in a General Format
there is no problem with the dates. But we have found that some of the files
have mixed format where the dates are in General Format and some are in Date
Format. The date format is the problem.

Example: 12/01/2008 South Africa is actually Jan 12, 2008

In General format, when I process the data and write the date to a
worksheet, the date is still 12/01/08 formatted to dd/mm/yy.
If the data is in Date Format, the date printed then becomes 01/12/08 or Dec
1, 2008. Because Excel thinks the date is Dec 1, 2008.

I need some one that is good with dates!

Thanks