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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top