Ask Your Question
3

What is the procedure for modifying the default number delimiter formatting in Excel?

asked 2022-09-26 11:00:00 +0000

nofretete gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2021-09-26 20:00:00 +0000

pufferfish gravatar image

The procedure for modifying the default number delimiter formatting in Excel is as follows:

  1. Open Excel and navigate to the "File" tab in the ribbon menu.
  2. Select "Options" from the drop-down menu.
  3. In the Excel Options dialog box, select "Advanced" from the left-hand menu.
  4. Scroll down to the "Editing options" section, and locate the "Use system separators" option.
  5. Uncheck the box next to "Use system separators."
  6. In the "Decimal separator" and "Thousands separator" fields, enter the characters you want to use as the default delimiter formatting for numbers.
  7. Click "OK" to save your changes.

After you follow these steps, Excel will use the specified characters as the default number delimiter formatting for all new workbooks you create. If you want to change the delimiter formatting for an existing workbook, you will need to modify those settings specifically in that workbook.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2022-09-26 11:00:00 +0000

Seen: 11 times

Last updated: Sep 26 '21