Altering text DATE into usable value

[Sweedler]

I have a download dump of data. In column C (starting from row 9) I have dates, but the download formats them as text into Excel (don't ask me why) ...

Using VBA ... What I need, ideally, is push every cell value through the formula "=Value(C9)" [and so on] and put that new value into the same cell. Is there a way to do this? I can make it work if the results are dumped in some random column off screen, but it would not be the most aesthetically pleasing. Please help me

 

[Fluff]

Have you tried using the text to columns option on the Data tab?

 

[Sweedler]

Have you tried using the text to columns option on the Data tab?

I have note tried that, but I have about 30-40 functions baked into a VBA right now that this needs to be a part of. Everything will be sorted with one button press.

 

[Fluff]

You can use text to columns in VBA as well. See if it works & if so just record yourself doing it & you have the code.

 

[Sweedler]

You can use text to columns in VBA as well. See if it works & if so just record yourself doing it & you have the code.

But would not text to column increase the number of columns? That is also a no go. The screen must remain as it is.

 

[Fluff]

But would not text to column increase the number of columns?

No. in T2C select delimited, next, clear all checkboxes, next, select the format the date is in, Finish

 

[Sweedler]

No. in T2C select delimited, next, clear all checkboxes, next, select the format the date is in, Finish

I tried what you said and got it recorded and put it into the code. Working nicely

 

[Fluff]

You're welcome & thanks for the feedback.