Forum Discussion
put 3 zeros with thousand option
how do I put 3 zeros with the option mil? use and I only get zeros
I am a beginner lmao
2 Replies
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.
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.
I know I don't know anything (Socrates)
What is 'mil'? Can you explain more clearly what you want.
