A little date formatting puzzle

[Cath]

Hi

Just got my array to work (thanks for the help everyone)

However I take a date, eg, 17/11/05 (format dd/mm/yy), it goes into an array, and if I check the value it is still 17/11/05. It is then entered into a cell (who's format is dd/mm/yy), but when I look at the results, it says 11/17/05 but strangely the format is still dd/mm/yy??

Has anyone any idea how to change this? I could understand if it had defaulted to m/d/y as I could just change it back, but now it actually has the wrong date in?

Thanks

Cath

 

[sebiwane]

just a small test - what's happen to the cell if you choose a number format?

does it show 38672 as result or still the same date than previous?

 

[Cath]

It still shows the same date as previous 11/17/05

 

[Harvey]

Did you accidentally put the date in as a string?

 

[Cath]

I'm not sure, the array is just defined as dim values (15). Should I define it as something else (not everything in there is dates, there is text and numbers)

 

[sebiwane]

i'm not expert in macro but you can maybe try :

Dim values(15) As Date

but you must store only date in the array

otherwise i dont think it will work.

 

[Cath]

I think will format all 15 values as dates.

 

[Cath]

Just tried dim values (7) as date but its come up with an error

 

[Harvey]

You can use something in the trend of:

dim temp as date
temp = values(i)
Cell(x, y).value = temp

 

[Cath]

The odd thing is now I can't reformat that data as anything, its stuck as 11/17/2005! All my previous ones that I saved at least could be changed?