Hi there, I am using text to column function via VBA - when record the macro i select "text" rather than "general" which works just fine. However when i run the macro from vba - it presets to general and therefore displays my split data as a time rather than as text