00:00so what you can also easily do inside of excel is format out special data as you need for example
00:12i'm going to go ahead and type in some random numbers right here and in order to in order to
00:16change this out i'm going to select this and i'm going to go around over here on to the number
00:22section expand it and then go to more number formats right here so now i'm going to go around
00:27over here onto special and here you can see that there's different type of special numbers that you
00:32can select for example there's zip code format right here there's zip code plus four right here
00:37if i were to press ok then you can see that this turns into a zip code format apart from that you
00:43can also go around over here onto more number format go to phone number type of format as well press ok
00:49then you simply have a phone number type format as you can see right here as i type apart from that
00:55if i were to go around over here onto more number format you can also change it out into a social
01:00security number format as you can see right here and these are the special formats that you can
01:05actually go ahead and choose right here and depending on different location right here just like this
01:11you can see that there are different sort of um numbers that you can go ahead and choose let's say
01:18for example if i were to go around over here onto united kingdom you don't really have much choices right
01:24here but in united states you can see that these are the four um special number types so depending on
01:31different uh reason right here if it is available then you will see the special type and you can go
01:37ahead and apply it out accordingly so that is how you can go ahead and format out special data
01:43inside of excel so if you found this video useful be sure to hit the like button don't forget to share
01:50this out with your friends and family and for more contents like these do follow simple tutorials
Comments