I don't have XP on this machine Barb, but I do have 2000, and format works
there, so it is bound to work in XP.

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in message
...
I've never done any VBA with 2002, but I wonder of Format is supported.
You
could try to use WorksheetFunction.Text to see if that works.

HTH,
Barb Reinhardt

"jc" wrote:

In trying to run a VBA macro on a EXCEL 2002 machine that has work on
other
EXCEL 2003 machines.

The code interupts with:

"Compile error: Can't find project or library"

on hitting OK it goes into the VBA editor.

The word "Format" is highlited

What do I need to get format to work?
--
CroceJC