preceed number with zeros

  • Thread starter Thread starter Dan S.
  • Start date Start date
D

Dan S.

I want my account number to be preceeded with zeros. instead of
account number 2, I want 0002. How can I customize the cell to do
that?

--

Yours,
Dan S.

Notably: not a sock
 
If it's just for display, you can use a custom format for the number. Format
Cells -> Number -> Custom. Enter 0000.
 
Barb said:
If it's just for display, you can use a custom format for the number. Format
Cells -> Number -> Custom. Enter 0000.
Click to expand...

How would I format the 0002 to be shown as a text string which could be
added to another text string.

eg A1 0002 A2 ABC A3 0002ABC [A1+A2]

Regards
 
You could use

=TEXT(A1,"0000") & A2

HTH,
Barb Reinhardt

newman said:
Barb said:
If it's just for display, you can use a custom format for the number. Format
Cells -> Number -> Custom. Enter 0000.
Click to expand...

How would I format the 0002 to be shown as a text string which could be
added to another text string.

eg A1 0002 A2 ABC A3 0002ABC [A1+A2]

Regards
Click to expand...
 
Barb said:
You could use

=TEXT(A1,"0000") & A2

HTH,
Barb Reinhardt

newman said:
Barb said:
If it's just for display, you can use a custom format for the number. Format
Cells -> Number -> Custom. Enter 0000.

:

I want my account number to be preceeded with zeros. instead of
account number 2, I want 0002. How can I customize the cell to do
that?

--

Yours,
Dan S.

Notably: not a sock
Click to expand...

How would I format the 0002 to be shown as a text string which could be
added to another text string.

eg A1 0002 A2 ABC A3 0002ABC [A1+A2]

Regards
Click to expand...
Click to expand...

Thank you

I have another question regarding fonts for the text and numbers string.
I am using Courier New to give a monospace effect but find that the
letters in this font are smaller than the numbers. Is there another font
that would give a better look?

Regards
 
I'm an Arial gal so you may want to ask someone else.

newman said:
Barb said:
You could use

=TEXT(A1,"0000") & A2

HTH,
Barb Reinhardt

newman said:
Barb Reinhardt wrote:

If it's just for display, you can use a custom format for the number. Format
Cells -> Number -> Custom. Enter 0000.

:

I want my account number to be preceeded with zeros. instead of
account number 2, I want 0002. How can I customize the cell to do
that?

--

Yours,
Dan S.

Notably: not a sock




How would I format the 0002 to be shown as a text string which could be
added to another text string.

eg A1 0002 A2 ABC A3 0002ABC [A1+A2]

Regards
Click to expand...
Click to expand...

Thank you

I have another question regarding fonts for the text and numbers string.
I am using Courier New to give a monospace effect but find that the
letters in this font are smaller than the numbers. Is there another font
that would give a better look?

Regards
Click to expand...
 
Barb Reinhardt formulated on Tuesday :
I'm an Arial gal so you may want to ask someone else.
Click to expand...
Arial: the old Courier New or is it the new Times Old Roman

--

Yours,
Dan S.

Resident Irish fan: stated embarassment for some, hero to others,
revered by all.
 
Back
Top