I want to convert numbers to text in Excel

[Hannibal]

i.e. 0000176 into exactly the same but as text. How do I do this?

[HiArt]

Hi,

if the number "176" is held in cell A!, then try:

=RIGHT("0000000" &TEXT(A1,0),7)

HTH

Art

[PeterB]

This raises a question with me - how is Hannibal getting numbers with leading 0's? When I have in the past tried to use leading 0's, Excel always removes them, unless I type it in & format as text.

[Otto Moehrbach]

Format the cell to Text before you enter the number. Or precede the entry
with an apostrophe. HTH Otto
"Hannibal" <Hannibal@discussions.microsoft.com> wrote in message
news:7A94F5A6-45B4-40F2-9D6D-84FF9A4C6095@microsoft.com...
> i.e. 0000176 into exactly the same but as text. How do I do this?

[HiArt]

Hi Peter,

you can still use the =RIGHT("0000000"&A1,7) construct, then the right align button. If, for example, you multiply this cell by 52, you still get a numeric answer, so perhaps this is the way to go.

Art

[XL Mak'Gyver]

I've used the following before:

=Text(A1,"0000000")

which works well if you have a standard format. If the number of preceeding zero's are going to change, then you might have to use some fancier formulas to determine the length & drive the number of zero's off of that (if even possible, not sure).

Not sure if this meets your need though.

[smart.daisy]

try to use formula text( )

"Hannibal" wrote:

> i.e. 0000176 into exactly the same but as text. How do I do this?

[PeterB]

you can still use the =RIGHT("0000000"&A1,7) construct, ...

Art

Thanks Art, Nice one!

Peter