![]() ![]() You can change the format of a cell’s value by either using various formats available in Excel or creating a custom format using number format code. You can even create custom symbols in Excel using this feature!īut before you understand how to add a symbol to a number in Excel, you need to first know how to write a number format code. ![]() This brings up the Format Cells dialogue box and under the Custom category, you can customize the Type to whatever you like. The key benefit of adding custom formatting is that it only controls how the number is displayed without changing the underlying value of that number.Ī cool feature within Excel is the ability to format a cell’s value by pressing CTRL + 1 on any cell. But if none of them meets your requirement, you will have to create your own. Excel has several in-built features to create custom formatting to your numbers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |