When you want to apply a minor tweak to the document, it should not take long to Fix numbers text. This kind of simple activity does not have to demand additional training or running through guides to learn it. Using the proper document editing instrument, you will not spend more time than is needed for such a swift edit. Use DocHub to simplify your editing process whether you are a skilled user or if it’s your first time using a web-based editor service. This tool will require minutes or so to learn to Fix numbers text. The only thing needed to get more effective with editing is a DocHub profile.
A plain document editor like DocHub can help you optimize the amount of time you need to devote to document editing no matter your previous knowledge about this kind of tools. Create an account now and enhance your productivity immediately with DocHub!
welcome to Excel magic number 1068 if you want to download this workbook 1067 to 1068 click on the link below the video hey in this video we want to talk about the text function and the fixed function for converting numbers either dates or numbers to text to create a label now the reason we have to use text and fixed is because we want to create labels which are text formulas formulas cant see this number formatting so here theres some custom number formatting control one oh look so its showing a separator for the thousands and two decimals and then here control one custom number formatting is M /dy while I so these are numbers that have number formatting but a formula cant see that number formatting so for example equals and Im going to create a label that says the sales so Im going to put in double quotes the sales all on end space and then n double quote and Im going to join it using the ampersand and what Id like is to have it show up as 2 7 2014 but of course that is a se