How can I prefill a text field with leading 0s?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list on Text data
ie 1, 14, 203, etc
I want them all to be 6 charcters long.
ie 000001, 000014, 000203, etc.
I can concatenate but the I would manually need to remove extra 0's Any
suggestions
 
Set the format to 000000 (Format>Cells>Custom)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
If it is for display purposes, you can format (numbers, not text) using a
custom format of "000000"

If you need the values to 6 characters you can use for numeric values:
=text(number, "000000")

For text values:
=rept("0",6-len(text value))&text value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert dollars and cents to text, and prefill the cell . 1
How can I concatenate text with leading zeros 2
remove leading zeros from text strings 2
Removing leading 0s 2
How do I add 2 leading 0s to a list of numbers 1
FP 2003: Prefilling fields on a hyperlink 5
converting numbers to text and prefill text field with 0's 2
How can I prefill a form? 7

Back
Top