I need to convert a number to text but I need it to be 5 position

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

Guest

I need to convert a number to text but it needs to be 5 positions. For
example of the number is 100, I need the text value to be 00100.

Any Ideas
 
Use a help column and a formula

=TEXT(A1,"00000")

where A1 holds 100, after you are done copying the formula, then select all
formula results and copy them, then paste special as values in place
 
=TEXT(A1,"00000")

--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.
 
=TEXT(A1,"00000")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need to convert a number to text but it needs to be 5 positions. For
| example of the number is 100, I need the text value to be 00100.
|
| Any Ideas
 
With
A1: 100

Try this:
B1: =TEXT(A1,"00000")

Is that something you can work with?
Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
You must log in or register to reply here.

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

Windows 7 I need to convert date to text 3
How do I associate text with a number? 1
Find position number of third space 6
Need a Function 3
Finding the weighted average of text that have been given values 1
2 issues really 3
Convert Numbers to Text 2
Change positive number to negative number 1

Back
Top