How to define specific format for number? [Solved/Closed]

ugn10 48 Posts Saturday October 27, 2012Registration date March 4, 2014 Last seen - Feb 27, 2014 at 01:52 PM - Latest reply: ugn10 48 Posts Saturday October 27, 2012Registration date March 4, 2014 Last seen
- 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
See more 

5 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Feb 27, 2014 at 06:18 PM
1
Thank you
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.

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1299 users this month

ac3mark 10639 Posts Monday June 3, 2013Registration dateModeratorStatus October 12, 2018 Last seen - 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
ugn10 48 Posts Saturday October 27, 2012Registration date March 4, 2014 Last seen - 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.
ac3mark 10639 Posts Monday June 3, 2013Registration dateModeratorStatus October 12, 2018 Last seen - Feb 27, 2014 at 03:30 PM
0
Thank you
OK, Text will do what you want as in =text(a1,"#-#-###")

Take a look:

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