Lots of difficulty trying to truncate/format a date column.
How do I take (sample): 2014-01-06 08:54:14.884000
And truncate it to 01/06/14 08:54:14
If I need to make compromises to make any truncation possible, I’m open to ideas.
Hi Palpenstein
A possible format for what you want is: DD/MM/YY HH:MM:SS
Here is how to do it:
- (Select the cell(s) containing the dates that you wish to format)
- (
menu):Format→Cells...(Ctrl+1) -
Number(tab)→Date - Place your code in
Format code
Codes can be found here:
If this helps then please tick the answer (
)
…and/or show you like it with an uptick (∧)