|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 19th, 2003, 02:55 PM
|
|||
|
|||
Convert date field to text
I have a mass of data with dates, which I need to group
by DAY. I have formatted the cell to custom "dddd" so that it shows the day, however when i pivot report it still reads the date. How can i convert the date field to text to read the day? A straight forward format of cell returns the date in number format. HELP! 
|
|
#2
December 19th, 2003, 03:07 PM
|
|||
|
|||
|
Convert date field to text
Perhaps a separate column with =weekday
=CHOOSE(WEEKDAY(B10),"S","M","T") -- Don Guillett SalesAid Software "Alan" wrote in message ... I have a mass of data with dates, which I need to group by DAY. I have formatted the cell to custom "dddd" so that it shows the day, however when i pivot report it still reads the date. How can i convert the date field to text to read the day? A straight forward format of cell returns the date in number format. HELP!
|
|
#3
December 19th, 2003, 03:12 PM
|
|||
|
|||
|
Convert date field to text
"Alan" wrote in message
... I have a mass of data with dates, which I need to group by DAY. I have formatted the cell to custom "dddd" so that it shows the day, however when i pivot report it still reads the date. How can i convert the date field to text to read the day? A straight forward format of cell returns the date in number format. HELP! Formatting cells doesn't change the data - only how the data is displayed. You can add another column with formulas to extract the day from the dates: =TEXT(A1,"dddd") Then make your pivot table from this.
|
|
#4
December 19th, 2003, 03:35 PM
|
|||
|
|||
|
Convert date field to text
Hi
=TEXT(DateReference,"dddd") -- (When sending e-mail, use address ) Arvi Laanemets "Alan" wrote in message ... I have a mass of data with dates, which I need to group by DAY. I have formatted the cell to custom "dddd" so that it shows the day, however when i pivot report it still reads the date. How can i convert the date field to text to read the day? A straight forward format of cell returns the date in number format. HELP!
|
|
#5
December 19th, 2003, 03:45 PM
|
|||
|
|||
|
Convert date field to text
Worked a treat - thanks Don
-----Original Message----- Perhaps a separate column with =weekday =CHOOSE(WEEKDAY(B10),"S","M","T") -- Don Guillett SalesAid Software "Alan" wrote in message ... I have a mass of data with dates, which I need to group by DAY. I have formatted the cell to custom "dddd" so that it shows the day, however when i pivot report it still reads the date. How can i convert the date field to text to read the day? A straight forward format of cell returns the date in number format. HELP! .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
