Excel Experts Help Ma Please

[Journey]

For example,

 

1234

12345

1285

15495

 

Ila unna numbers lo only 4 digit unna numbers ki mundu 0 ravali ante ela?

 

Kinda laga ipovali

 

01234

12345

01285

15495

 

Koncham cheppi punyam kattukondi

[chalkpiece]

For example,

 

1234

12345

1285

15495

 

Ila unna numbers lo only 4 digit unna numbers ki mundu 0 ravali ante ela?

 

Kinda laga ipovali

 

01234

12345

01285

15495

 

Koncham cheppi punyam kattukondi

1. Select the cells u want to modify

2. Right Click and select format cells

3. Go to number tab 

4. Select Custom (the last option)

5. Type 00000

and click Ok

[micxas]

:3D_Smiles_153:

1. Select the cells u want to modify

2. Right Click and select format cells

3. Go to number tab 

4. Select Custom (the last option)

5. Type 00000

and click Ok

 

[ramu]

Formatting lo special lo zipcode type select chesthe vastundhi... see if it works for u

[chalkpiece]

Formatting lo special lo zipcode type select chesthe vastundhi... see if it works for u

seven digits kavalante mari?

[chalkpiece]

:3D_Smiles_153:

nee mixy pani chestunda inka 

[Aryaa]

Formatting lo special lo zipcode type select chesthe vastundhi... see if it works for u

Zip code 5 digits ki matrame work avutundi

[siru]

For example,

1234
12345
1285
15495

Ila unna numbers lo only 4 digit unna numbers ki mundu 0 ravali ante ela?

Kinda laga ipovali

01234
12345
01285
15495

Koncham cheppi punyam kattukondi

Cheppesi edo full ga cheppamanu bro..
Koncham chebthe migatadi elaga?

[ramu]

seven digits kavalante mari?

pina cheppav ga custom format... adi vadukotame...

[chalkpiece]

Zip code 5 digits ki matrame work avutundi

maku telsule 

[micxas]

nee mixy pani chestunda inka 

Yeah, perfectly 

[chalkpiece]

Yeah, perfectly 

aithe kidesi tokku 

[chalkpiece]

Zip code 5 digits ki matrame work avutundi

neku chadastam ekkuvaindi uncle 

[Journey]

1. Select the cells u want to modify

2. Right Click and select format cells

3. Go to number tab 

4. Select Custom (the last option)

5. Type 00000

and click Ok

 

 

Formatting lo special lo zipcode type select chesthe vastundhi... see if it works for u

Rendu processlu worked.. Thanks...  

[Journey]

Cheppesi edo full ga cheppamanu bro..
Koncham chebthe migatadi elaga?

Mistake ipoyindi bayya next time nundi alage follow avutha