data in formula and how to use pivot table

[ramzi]

Dear All,

My data in formula . How i'm going to use pivot table b'cos pivot table
doesn't recognize my value (results form formula) , he only take as a formula.

e.g.
=[purchase_entry.xls]sale!$B893 and the results is Jan

the pivot table cannot recognise the particular cell as Jan.

 

[muddan madhu]

the cell B893 has date or name "JAN" ?

if it is date and if u are formated as mmm then it wont.

 

[Max]

=[purchase_entry.xls]sale!$B893 and the results is Jan

the pivot table cannot recognise the particular cell as Jan

One guess is that you want the link to be "seen" as a date?
Try something like this:
= --(1& [purchase_entry.xls]sale!$B893 &2009)
which makes it into an unambiguous date, 1st Jan 2009
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

 

[ramzi]

hi Muddan,

i format as mmm...

the cell B893 has date or name "JAN" ?

if it is date and if u are formated as mmm then it wont.

Dear All,

My data in formula . How i'm going to use pivot table b'cos pivot table
doesn't recognize my value (results form formula) , he only take as a formula.

e.g.
=[purchase_entry.xls]sale!$B893 and the results is Jan

the pivot table cannot recognise the particular cell as Jan.

 

[muddan madhu]

try this
replace formula to

=Text([purchase_entry.xls]sale!$B893,"mmm")

hi Muddan,

i format as mmm...

the cell B893 has date or name "JAN" ?

if it is date and if u are formated as mmm then it wont.

Dear All,
My data in formula . How i'm going to use pivot table b'cos pivot table
doesn't recognize my value (results form formula) , he only take as aformula.
e.g.
=[purchase_entry.xls]sale!$B893  and the results is Jan
the pivot table cannot recognise the particular cell as Jan.- Hide quoted text -

- Show quoted text -