if enter the number in cell ( A1 ) out put need to come in ( a1 ) for =TEXT(A1,"10000000000")

[shrinivasmj]

i need to enter the no like 456897 in ( a1 ) cell and out put should come as 10000456897 in cell (a1) only

FOR THIS FORMULA

=TEXT(A1,"10000000000")

and

 

[mikerickson]

Format the cell with the custom number format 10000000000

 

[shrinivasmj]

thanks a lot

 

[shrinivasmj]

Format the cell with the custom number format 10000000000

if i do past special it will take only the no what i entered like 4785456 but its only display like 10004785456

 

[S.H.A.D.O.]

Hi shrinivasmj,

Format the cell with the custom number format 10000000000

I think he meant format it as:

00000000000

I hope this helps.

 

[mikerickson]

No I didn't mean that, I meant that the custom number format of the cell should include the extra leading 1.

I'm not sure what the OP wants.

The user types 1234

Does the OP want the cell to show 1000001234 and contain the value 1234

or does the OP want the cell to contain the value 1000001234?

 

[S.H.A.D.O.]

Appolgies mikerickson,

No I didn't mean that, I meant that the custom number format of the cell should include the extra leading 1.

I'm not sure what the OP wants.

The user types 1234

Does the OP want the cell to show 1000001234 and contain the value 1234

or does the OP want the cell to contain the value 1000001234?

On reflection, I too am unsure now what the OP wants.

 

[shrinivasmj]

hi,
i have Format the cell with the custom number format 10000000000
when i type 589756 its display 100000589756

when i try to copy paste the data to other cell its paste only 589756 need to copy paste the complete data like 100000589756

 

[S.H.A.D.O.]

Hi shrinivasmj,

if i do past special it will take only the no what i entered like 4785456...

I have tried copy & paste and it works fine.
Just try copy & paste and NOT copy & paste special and see if you still have the same problem.

 

[mikerickson]

Rather than using copy/paste as a test, what do you want the formula =A1+1 to return?