Simple? Formatting Question

[John Baker]

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

 

[Norman Jones]

Hi John,

Use a custom format of 000

 

[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

 

[Tom Ogilvy]

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

or use Left.

then format as posted.

 

[Tom Ogilvy]

select the cell

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

 

[John Baker]

Thank you Tom

 

[Jamie Collins]

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.

--