Number Formatting

Pratibha Sharma

unread,

Oct 6, 2015, 12:08:20 AM10/6/15

to Excel VBA Lab

Dear All,

I have data in A Column like :

Numbers
13456544444
13456544644
13456544844
13456545044
13456545244
13456545444
13456545644
13456545844
13456546044

Out Put Required :

Numbers
1-345-654-4444
1-345-654-4644
1-345-654-4844
1-345-654-5044
1-345-654-5244
1-345-654-5444
1-345-654-5644
1-345-654-5844
1-345-654-6044

Kindly help.

Thanks & Regards

PS

Ashish Bhalara

unread,

Oct 6, 2015, 1:16:00 AM10/6/15

to Excel VBA Lab

Hello Sharmaji,

To change number format, goto Format Cells (Ctr+1), select Category of Custom in Number Field and type #-###-###-#### in text box of Type. It will change formatting for Number.

Regards

Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/34102c25-15bd-497e-9468-598d9bb04b67%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Pratibha Sharma

unread,

Oct 6, 2015, 2:15:47 AM10/6/15

to Excel VBA Lab

Dear Ashish Bhalara,

Thanks a lot for your help.

I want one more help in number formatting.

Can i share 1 more query in this thread.

Thanks & Regards

PS

Pratibha Sharma

unread,

Oct 6, 2015, 2:22:30 AM10/6/15

to Excel VBA Lab

Dear Ashish Bhalara,

Most of the time when i was enter any number like : - 00000456 it will be punched in excel but disappear all "zeros" and reflected as like 456

kindly share the easiest way to resolve this problem

Thanks & Regards

PS

Ashish Bhalara

unread,

Oct 6, 2015, 2:39:33 AM10/6/15

to Excel VBA Lab

Wellcome Sharmaji,

If you want to write zero as prefix, you can use colon(') before writing number like '0000456, but or you can also change Cell Formatting as Text. This type of number can not calculated.

If you want to calculate this type of number and number of prefix zero is fix then you can change cell Number Custom Type format as "0000###" or "0000###0.00" and various type of format can change by using of # and 0(zero).

You can see attached file to know various type cell formats.

Regards

Ashish Bhalara

--

www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.

To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/a4f0858a-cef7-48bc-9eb1-926d74a6afde%40googlegroups.com.

Custom cell format.xls

Pratibha Sharma

unread,

Oct 6, 2015, 2:48:12 AM10/6/15

to Excel VBA Lab

Dear Ashish Bhalara,

Thanks a lot :)

Explained very well.

Specially thanks for explaining the whole scenario of cell formatting and calculation of formatted cells.

Thanks & Regards

PS

Ashish Kumar

unread,

Oct 6, 2015, 4:23:07 AM10/6/15

to Excel VBA Lab

Dear Ashish Bhalara,

Well Explained...!!

@ All Group Members,

Request you to please check the Sheet which is shared by Mr. Ashish Bhalara for Custom Cell Formatting. It's very useful and having good tips and tricks of Custom Formatting.

Regards

Ashish Kumar

Ashu K

unread,

Oct 6, 2015, 10:12:50 AM10/6/15

to Excel VBA Lab

Dear Ashish Bhalara Sir,

Thankyou for explaining and sharing useful excel sheet for Custom formatting.

Thanks & Regards

Ashu Kenith

Reply all

Reply to author

Forward