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

Hi Again:

I should have added that the field in question is being concatenated with other fields to
produce the unique key. Hence I need something that will LOCK the format TO THREE DIGITS
when I concatenate.

John


John Baker wrote:

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

=Right(A1&B1&C1,3)*1

or use Left.

then format as posted.

--
Regards,
Tom Ogilvy



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

I should have added that the field in question is being concatenated with
other fields to
produce the unique key. Hence I need something that will LOCK the format
TO THREE DIGITS
when I concatenate.

John


John Baker wrote:

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

Hi John,

Use a custom format of 000


---
Regards,
Norman



"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

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

Thank you Tom

"Tom Ogilvy" wrote:

select the cell

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

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.

--