| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Removing characters from datetime field
I have an XL sheet with data in the format "07/07/2005 10:00:00". I need it
in the format "07/07/2005 10:00", so that I can create a pivot table with the date and count of some records. How do I make the date in this format. Tried the formatting, but it works incorrectly in the pivot table. Pls help... |
|
#2
|
|||
|
|||
|
Are you sure the raw data is really date/time?
If you put this in an unused cell =count(a2:a99) in a cell (use the correct range) And this in another: =counta(a2:a99) do you get the same results? Sujesh wrote: I have an XL sheet with data in the format "07/07/2005 10:00:00". I need it in the format "07/07/2005 10:00", so that I can create a pivot table with the date and count of some records. How do I make the date in this format. Tried the formatting, but it works incorrectly in the pivot table. Pls help... -- Dave Peterson |
|
#3
|
|||
|
|||
|
tried the formula for a certain number of cells in the xl sheet. the results
that I got were the same. -- Sujesh R. Nair "Dave Peterson" wrote: Are you sure the raw data is really date/time? If you put this in an unused cell =count(a2:a99) in a cell (use the correct range) And this in another: =counta(a2:a99) do you get the same results? Sujesh wrote: I have an XL sheet with data in the format "07/07/2005 10:00:00". I need it in the format "07/07/2005 10:00", so that I can create a pivot table with the date and count of some records. How do I make the date in this format. Tried the formatting, but it works incorrectly in the pivot table. Pls help... -- Dave Peterson |
|
#4
|
|||
|
|||
|
When I had dates/times in my pivottable, I could select those cells in the
pivottable and format them the way I wanted. But that didn't work for you??? What happened? Sujesh wrote: tried the formula for a certain number of cells in the xl sheet. the results that I got were the same. -- Sujesh R. Nair "Dave Peterson" wrote: Are you sure the raw data is really date/time? If you put this in an unused cell =count(a2:a99) in a cell (use the correct range) And this in another: =counta(a2:a99) do you get the same results? Sujesh wrote: I have an XL sheet with data in the format "07/07/2005 10:00:00". I need it in the format "07/07/2005 10:00", so that I can create a pivot table with the date and count of some records. How do I make the date in this format. Tried the formatting, but it works incorrectly in the pivot table. Pls help... -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i step thru a text field looking for 6 numeric characters | Excel Worksheet Functions | |||
| How do I remove the 1st 4 characters of a field in Excel? | Excel Worksheet Functions | |||
| removing character from field | Excel Worksheet Functions | |||
| removing some of the characters from a cell | Excel Discussion (Misc queries) | |||
| Removing the : in the coment field | Excel Discussion (Misc queries) | |||
Linear Mode
