answersLogoWhite

0

Format | Format Cell | Number Tab | Number -- Click box in front of "Use 1000 Separator"

>> In Excel this type of format is known as "accounting number format"

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What excel number format inserts thousand comma separators?

the excel number format that applies a thousand comma separate where appropriate inserts a fixed us dollar sign aligned at the left edge of the cell applies two decimals places and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers is the what? The answer is accounting number format


What Excel number format inserts thousand comma separators fixed dollar sign leaves small space for negative numbers?

You have the comma style that will do it from the toolbar, or you can do it by using the numeric format called Number and ticking the "Use 1000 Separator" tick box.


What effect does the comma style format have on the selected cells for Excel?

The comma style will format numbers with two decimal places and insert commas as thousand separators. So if you had a number like 3455679 in a cell and formatted it as comma style, it would come up as:3,455,679.00


When you change from a one column format to a two-column format word inserts a what?

section break


Word inserts what when you switch from one column format to two column format?

a second column


When you change from one columne format to a two column format word inserts what?

section break


What effect does the comma style format have on selected cells?

It puts commas in to break the groups of thousands. They are sometime called thousand separators. Before being formatted you could have a number like 16777216. When it is formatted to the comma style it will appear as 16,777,216.00 including the two decimal points at the end. They can be removed if you wanted.


When you change from a one- column format to a two-column format word inserts a?

Word may insert a section break, if there is a part of the document in one column format and another part in a two column format.


When you change from one-column format to a two column format Word inserts a?

Word may insert a section break, if there is a part of the document in one column format and another part in a two column format.


Format that displays a dollar sign to the left of the number and inserts commas?

You can achieve this format using the following custom number format: "$#,##0.00". This format will display the dollar sign to the left of the number and insert commas for thousands separator.


When designing data entry screens provide an on-screen instruction to let users know the date format and provide an example if the user must enter?

Separators


How do you format a USB?

Insert the device into an appropriate socket, right-click the device and select format.