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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I need to convert a number to text but I need it to be 5 position (https://www.excelbanter.com/excel-worksheet-functions/138466-i-need-convert-number-text-but-i-need-5-position.html)

Mike L.

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

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

Peo Sjoblom

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

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

--
Regards,

Peo Sjoblom

"Mike L." <Mike wrote in message
...
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

Gary Brown

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

=TEXT(A1,"00000")

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.

"Mike L." wrote:

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

Niek Otten

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

=TEXT(A1,"00000")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mike L." <Mike wrote in message ...
|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

Ron Coderre

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

With
A1: 100

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

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

XL2002, WinXP

"Mike L." wrote:

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

Bob Umlas, Excel MVP

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

Format/Cells/Custom tab, enter 00000
Bob Umlas
Excel MVP

"Mike L." wrote:

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

All times are GMT +1. The time now is 11:16 PM.