John Baker wrote:

there is no simple "Format" command as there is
in Access!

Are you sure MS Access has a Format command? VBA has Format and Format$
functions but then Excel shares the same VBA library as MS Access. Jet
has Format and Format$ functions, basically a re-implementation of the
equivalent VBA5 functions, but then Excel is a Jet data source too.
Some of the MS Access Forms controls have a Format property, is *this*
what you mean?

Jamie.

--