------ Register to get rid of these "In Post" ads! ------


Format the cell as General (or anything but Text).

Then reenter the formula.

The workbook has to be saved at least once for this to work, too.

If that doesn't help, maybe you're looking at formulas.

In xl2003 menus:
Tools|Options|View Tab|Uncheck Formulas

In any version:
ctrl-` (control-backquote, the key to the left of the 1/! on my USA keyboard).

DianePDavies wrote:
>
> It doesn't work...
>
> If I paste the suggestion into my cell - then that is just what is diplayed.
>
> Same for the suggestion by NBVC.
>
> So I am propably doing something wrong: I mark the cell and paste e.g.
> =CELL("filename",$A$1)
> in that cell. I can see that CELL is a function - but somehow it is not
> recognized by my sheet? What do I have to set to activate this function?
> --
> Diane
>
> "Jacob Skaria" wrote:
>
> > Try the below in a saved workbook.
> >
> > (all in one line)
> > =LEFT(CELL("filename"),FIND("[",CELL("filename"))-1)&MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)
> >
> > If this post helps click Yes
> > ---------------
> > Jacob Skaria
> >
> >
> > "DianePDavies" wrote:
> >
> > > How do I display the filename and path in a cell? I dont want it in the
> > > header - but I want it in a cell as I want to link to that cell from a word
> > > document.
> > > --
> > > Diane

--

Dave Peterson