Forum Discussion
Solved
Help in splitting a non stand excel date and time
11 July 2014 12:00:00 I have a column with data an time in the format above ,I am finding it difficult to split I have tried INT fuction, text to colum function ,concatenate function stil...
- CTRL+1 is a shortcut to access the Format Options.
There you can select or create your custom format for the cell you will apply to.
As I said, if you just want the date format only make reference to the cell where there is a full date format =A2 and apply your desired format using the format Option accessed by CTRL+1
clt + 1 does not do anything used it before
CTRL+1 is a shortcut to access the Format Options.
There you can select or create your custom format for the cell you will apply to.
As I said, if you just want the date format only make reference to the cell where there is a full date format =A2 and apply your desired format using the format Option accessed by CTRL+1
There you can select or create your custom format for the cell you will apply to.
As I said, if you just want the date format only make reference to the cell where there is a full date format =A2 and apply your desired format using the format Option accessed by CTRL+1
- Thank you so much ,it worked like a charm