put 3 zeros with thousand option

Copper Contributor

how do I put 3 zeros with the option mil? use and I only get zeros

I am a beginner lmao

2 Replies

@Santiago069 

What is 'mil'? Can you explain more clearly what you want.

@Santiago069 

As already mentioned, more detailed information such as Excel version, operating system, storage medium would help.

Please keep in mind that nobody here can see what you can see on your monitor.

Nevertheless send you some links on this topic. Maybe this information will also help you.

 

Format numbers as currency

If you want to display numbers as monetary values, you must format those numbers as currency. To do this, you apply either the Currency or Accounting number format to the cells that you want to format.

 

Available number formats in Excel

In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers.

 

NikolinoDE

I know I don't know anything (Socrates)