try this
replace formula to

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




On Jan 28, 2:54*pm, ramzi wrote:
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.- Hide quoted text -

- Show quoted text -