Also see Custom Formats | Convert a Numeric Value into English Words | Convert a Currency or Value into English Words
One of the most important things to do in Excel is to keep numbers as numbers and text as text. Sadly, many end up mixing the 2 and find it hard or impossible to do further downstream calculations on their numbers as they have either formatted the cell as Text or mixed text and numbers in the same cells. See Excel Best Practice for more common mistakes.
Using Excel's Custom Formats we eliminate the need to format numeric cells as Text and mix text and numbers in the same cell. For example, suppose you need to show Meters2 in certain cells. This is quite easy to do with a custom number format.
Select any empty cell and go Insert>Symbol and insert the symbol required. Superscript 2 in this example.
Now, with the cell containing the symbol selected, click in the Formula Bar, highlight the symbol and copy (Ctrl+c)
Now select the range that should show Meters2 after their entered numbers and go Format>Cells - Custom.
Use either General "Meters²";-General "Meters²" or 0.00 "Meters²";-0.00 "Meters²" or another variation by pasting in the symbol (Ctrl+v).
Note the use of - in second format segment. Excel see a cells format as having four Sections. These are, from left to right Positive numbers, Negative Numbers, Zero Values and Text values. Each of these Sections are separated by a semi colon (;). If you create a custom number format you do not have to specify all four sections. By this I mean, if you included only two sections, the first section would be used for both positive numbers and zero values, while the second section would be used for negative numbers. If you only used one section, all number types would use that one format. Text is only affected by custom formats when we use all four sections, the text would use the last section. See Custom Formats for full details and many more cool number formats.
Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates