There is probably an easier way, but in C1 enter:

=CELL("filename",A1)
this will display something like:

C:\Documents and Settings\Owner\Favorites\Links\e\spreads\[sendkey
experiment.xls]Sheet1

Note the extension is buried in there. The in another cell:

=IF(LEN(C1)=LEN(SUBSTITUTE(C1,"xls","")),"not xls","xls")
--
Gary''s Student - gsnu200841


"EvilTony" wrote:

Hi,

Is it possoble for an Excel cell to 'know' what type of file it belongs to?

In other words, if a file is a template (ABC.xlt), can I display one value,
and if it has been saved as a workbook (ABC.xls) can I display a different
value?

I need to show/hide a prompt to save the file as a workbook after a change
has been made to the template.

--
It''s a little fit bunny, this feeling inside