Or if your formula was just:

=sheet1!a1

just format the cell the way you want (format|cells|number tab)

CLM wrote:

I have some notations in a cell and then I have added a link to another
spreadsheets' field that is a date. When I look at the information the date
is given in Julian format. How do I get it to be in mm/dd/yyyy format?
Excel 2000.

Thx,

CLM

--

Dave Peterson