How to define specific format for number?

Solved/Closed
ugn10 Posts 48 Registration date Saturday October 27, 2012 Status Member Last seen March 4, 2014 - Feb 27, 2014 at 01:52 PM
ugn10 Posts 48 Registration date Saturday October 27, 2012 Status Member Last seen March 4, 2014 - Mar 4, 2014 at 10:07 AM
Hi,
I would like to define specific format in excel.

For example, if I type 123456789 and hit Enter, it should be 123-456-789 or 123-45-6789 automatically or any other format like...if I type 22543345, it should be 0124-22543345 after hitting Enter automatically.

Regards
GN Jha

2 replies

Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Feb 27, 2014 at 06:18 PM
ugn10, Good evening.

Try to do like this:

Select the cell you want to format
--> Menu Format
--> Number
--> Personalized
--> ###-##-####

Please, tell us if it worked for you.
I hope it helps.
1
Blocked Profile
Feb 27, 2014 at 06:21 PM
Right on, I forgot about the menu option! Thank you so much, as I am always in favor of using built-in functions. Thanks again!

//ark
0
ugn10 Posts 48 Registration date Saturday October 27, 2012 Status Member Last seen March 4, 2014
Mar 4, 2014 at 10:07 AM
Nice...Thanks...it worked but
In my queries there are two things...I got solution for one.
How to fix..following...
I want to define cell format as following...
If I put value 22554444, after hitting Enter it must be 011-22554444.
0
Blocked Profile
Feb 27, 2014 at 03:30 PM
OK, Text will do what you want as in =text(a1,"#-#-###")

Take a look:

0
ugn10 Posts 48 Registration date Saturday October 27, 2012 Status Member Last seen March 4, 2014
Mar 4, 2014 at 10:07 AM
Thanks...it worked...
0