Note that entering a number with a decimal point after making this change (ex – 12.34) can result in difficulty executing formulas. Any cell containing a decimal separator, regardless of its’ formatting, will be replaced with whatever you choose to use instead of a decimal point. This is not specific to only the currency or accounting formatted-cells. The steps below are going to change all of your decimal separators in Excel 2013. Use a Different Decimal Separator in Excel 2013 Our guide will teach you how to change the default decimal point to another symbol of your choosing, which will modify the way that your data is presented within the cells of your Excel worksheet. This is a situation that can occasionally come up when you are formatting a spreadsheet that will be read and viewed by others, so it is useful to know where to go to make this change. You might want to learn how to change the decimal separator in Excel 2013 if you are finding that your workplace or school requires you to use something else to identify a decimal, such as a comma.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |