Thread: Fill the Cell with Zeros upto a fixed number of characters

i have to type the amount in Rs and Paise in a column

i.e.
2500.11
26890.00
6565.49
3232.00


etc.........

now i want the output in adjacent column as
0000000250011
0000002689000
0000000656549
0000000323200

(this is needed for creating an input file)

somebody please help giving some formula for this

Thanx in advance

Hi hsmeet,

The following works on data starting at cell A2 - change as required and copy down as required:

=TEXT(LEFT(A2,SEARCH(".",A2)-1)&RIGHT(A2,2),"0000000000000")

HTH

Robert

Or =TEXT(100*A2, "000000000000")

Respected Trebor76 and shg(M)

i m very much grateful for your kind and timely help...

You people are rocking

both the formulas are working best though shg(M) made it more simple for
a user like me to understand....

thanks sir,

You're welcome. Excel usually provides several ways of getting to about the the same result; on another occasion, Trebor's approach may be just what you need.