date stamp

J

jdorion

I am a new user to excel and would like to know how I put a stamp in the
corner of my workbook that says the file that it is under. Ex
h:\xw\...
Also would this change if I change the file it is in.

Thankyou

Jessica
 
J

J.E. McGimpsey

One way:

=LEFT(CELL("filename",A1), FIND("]", CELL("filename",A1)))

Note that the file must be saved for this to work.
 
Top