Forum Discussion
How do I split up a cell containing a date?
I have an Excel document with over 4,000 rows in it, and many in one column are dates. I need to split it so I can run a PHP import, so it matches with our database. If I do =left(W6,2), I as...
And one more point - if use Text to Columns in first column will appear something like 13/01/1900. If select and apply General format it returns back to 13.