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
ugn10 Posts 48 Registration date Saturday October 27, 2012 Status Member Last seen March 4, 2014 - Mar 4, 2014 at 10:07 AM
Related:
- How to define specific format for number?
- Define network card - Guide
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- How to format hp laptop - Guide
- How to change whatsapp time format - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 27, 2014 at 06:18 PM
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.
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.
OK, Text will do what you want as in =text(a1,"#-#-###")
Take a look:
Take a look:
ugn10
Posts
48
Registration date
Saturday October 27, 2012
Status
Member
Last seen
March 4, 2014
Mar 4, 2014 at 10:07 AM
Mar 4, 2014 at 10:07 AM
Thanks...it worked...
Feb 27, 2014 at 06:21 PM
//ark
Mar 4, 2014 at 10:07 AM
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.