hi Muddan,

i format as mmm...

"muddan madhu" wrote:

the cell B893 has date or name "JAN" ?

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



On Jan 28, 1:00 pm, ramzi wrote:
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.