![]() Also, you can use any number or symbol instead of # as the formatting code. ![]() As usual, you can also select any other formatting codes from the pre-existing ones. ![]() You will find a sample of the formatting code you have inserted under the ‘Sample’ option for your convenience.For example, if you would type this ‘#-#-#’, then the Dash would be inserted after every 2 numbers. Here, # denotes the actual numbers, and the ‘-’ refers to actual Dash. This particular formatting code will insert the Dash after every 3 numbers.For example, you can type this or copy and paste this ‘#-#-#’ and click on the ‘OK’ button.You might have to delete the words ‘General’ from that box first if it is there. To add new formatting codes, select the ‘Custom’ option from the ‘Category’ pane and type your own code on the ‘Type:’ box.You can use them, or you can add your format codes. On the right side, you will find a few format codes.Now, click on the ‘Custom’ option from under the ‘Number’ tab. In doing so, the ‘Format Cells’ window will appear. ![]()
0 Comments
Leave a Reply. |