ANother Question
 

If I have a value in Cell B:31
and I want to reference this cell in Cell B32 and add the current date the
following way how would I do it?


For instance

B:31=
ENG
I want B32 to display something like: =B31&Date."bat"
So finally cell 32 would look like: ENG6/29/07/.bat

ANother Question
 

Try this:

=B31&TEXT(TODAY(),"m/d/yy/")&".bat"

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"N.F" wrote in message
...
If I have a value in Cell B:31
and I want to reference this cell in Cell B32 and add the current date the
following way how would I do it?


For instance

B:31=
ENG
I want B32 to display something like: =B31&Date."bat"
So finally cell 32 would look like:
ENG6/29/07/.bat