KEEPING CONSTANT NUMBER OF DIGIT IN OUTPUT

[guna_sekar87]

IF ME A FORMULA TO HAVE ONLY 6 DIGIT OUPUT DATA WHATEVER MAY BE THE GIVEN INPUT DATA :


eXAMPLE:


INPUT: OUTPUT


154689 154689

123 000123

124567875 124567

1 000001

36 000036

1548 001548

 

[Hui]

=TEXT(LEFT(A2,MIN(LEN(A2),6)),"000000")

[pre]

154689	154689
123	000123
124567875	124567
1	000001
36	000036
1548	001548

[/pre]

ps: NO NEED TO SHOUT !

 

[Debraj]

Hi Guna..


Partial Cross Post also


http://chandoo.org/forums/topic/cutting-and-adding-two-datas


Regards,

Deb