select the cell

format=Cells=Number Tab,
Go to Custom
Enter
000

--
Regards,
Tom Ogilvy

"John Baker" wrote in message
...
Hi:

I have a numeric cell, which I wish to always show as three digits (001
for example). I
find that I don't know how to do that, and there is no simple "Format"
command as there is
in Access! Can someone give me a pointer? The problem is that the cell has
to be
incremented in the processing, since it represents a sub sequence number
which ultimately
becomes unique key.

Thanks in advance

John Baker