Deleting X number of characters from multiple cell

[sousys]

Hello!

Im trying to figure out how to edit multiple cells at one time. I have cells with date and time and i want to edit them to only show Date.
Basicly i want to remove the last 6 characters of selected cells.

From
2010-12-30 19:31
to
2010-12-30



I tried to search the forum but found nothing that helped be, so i appologize if this has been anwered in previous post somewhere.

Thanks in advance!

/m

 

[SteveO59L]

Format the cells as

yyyy-mm-dd

 

[sousys]

Oh god that was so simple im embarassed...

Thank you!

 

[SteveO59L]

Only easy, if you know how

 

[sousys]

Turns out this didnt quite fix my problem.

When i turn my datasheet into a pivot-table, it still makes seperates each entry into date+time.. What i want to do is aggregate the entries into Days.
Is there anyway for the PivotTable to keep the new format?

In other words, if i change a collum of Date+Time into say Month-names, i want that collum to be represented by the Months of the year and not all the individual thousands of date+time entries in the data. Did that make sense?

Basicly i want to get statistics out divided into months

/m

 

[SteveO59L]

In your Pivot Table, you should find an option to Group Values. Select Month as your grouping criteria

 

[sousys]

Perfect! Thanks again!