date stamp

  • Thread starter Thread starter jdorion
  • Start date Start date
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
 
One way:

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

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