Numbers as Text
 

I want to convert the number 12345678, etc. into Text with 10 digits, with
leading zeros, when necessary, i.e. 0012345678.

I first formatted the 8 digit number to a 10 digit one with the Format Cells
Dialog Box (0000000000) and then format it as Text. But whenever I do that,
the leading zeros get lost and the values remain numbers!

How can I format the Cells that the values remain "0000000000" (=text)

Felix

Numbers as Text
 

In a helper cell...............

=TEXT(12345678,"0000000000")

Or =TEXT(cellref,"0000000000")


Gord Dibben MS Excel MVP

On Mon, 4 Aug 2008 20:59:01 -0700, Felix
wrote:

I want to convert the number 12345678, etc. into Text with 10 digits, with
leading zeros, when necessary, i.e. 0012345678.

I first formatted the 8 digit number to a 10 digit one with the Format Cells
Dialog Box (0000000000) and then format it as Text. But whenever I do that,
the leading zeros get lost and the values remain numbers!

How can I format the Cells that the values remain "0000000000" (=text)

Felix