answersLogoWhite

0

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.

User Avatar

Wiki User

15y 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 is a valid character for use in a number entry in excel?

In Excel, valid characters for use in a number entry include digits (0-9), a decimal point (.), and a negative sign (-) for negative numbers. Additionally, numbers can include commas (,) as thousand separators, depending on regional settings. However, other characters such as letters or special symbols (except for the ones mentioned) are not valid in number entries.


How do you write two thousand in numbers?

Two thousand is written 2000. Some countries use separators to mark off thousands and millions. In England and Ireland these are usually commas, and 2000 would be written as 2,000.


Are negative numbers such as 200 rounded to the nearest thousand 1000 or 0?

Zero


How do you say 1000000000?

When trying to work out how to pronounce large numbers it helps to put in the separators - so that 1000000000 becomes 1,000,000,000. This makes it easier to see the thousands and millions etc. That is spokeof as either "a billion", or "a thousand million".


What are the numbers -3-2-10123 what does it mean?

It would appear that these are a selection of numbers from Z, the set of integers - written without any separators.


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


How many keystrokes are needed to type numbers from 1 to 1000000?

For only the digits: 5,888,896. More if there are commas as thousands separators (as in this answer), or spaces between numbers (999,999 of those).


This button displays when the autoformat feature inserts numbers?

Auto-correct options


What is the sign of the product of a three negative numbers?

The product of three negative numbers is negative.


What type of numbers is the sum of two negative numbers?

They will be negative numbers as for example -5+(-7) = -12


Is a negative a whole numbers?

No. Whole numbers are counting numbers and zero.