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

Report
Posts
48
Registration date
Saturday October 27, 2012
Status
Member
Last seen
March 4, 2014
-
Posts
48
Registration date
Saturday October 27, 2012
Status
Member
Last seen
March 4, 2014
-
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

Posts
1854
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 4, 2020
136
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Blocked Profile
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
Posts
48
Registration date
Saturday October 27, 2012
Status
Member
Last seen
March 4, 2014

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.

OK, Text will do what you want as in =text(a1,"#-#-###")

Take a look:

Posts
48
Registration date
Saturday October 27, 2012
Status
Member
Last seen
March 4, 2014

Thanks...it worked...

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!