thousand separator

  1. E

    Keeping the thousand separator when thousands

    Hi there, I need to display numbers in thousands and to two decimal places. So for example 6,789,782 as 6,789.78 I have used the custom number formatting 0.00, which returns 6789.78. If I then format the cell as a number to add back the comma thousand separator, the whole number comes back...
  2. HarrysPrinters

    Thousand Separator

    I have data which needs to be formatted with a thousand separator as below. 400.00 1,000.00 250,000.00 how can I do this without it displaying as below ,400.00 I do not want it reflected in the case of hundreds. Many thanks
  3. J

    Japanese currency custom format

    Hi, I would like to set the format of a cell to the Japanese currency format. This means that the comma separator occurs at 4-digit interval instead of 3 (ten-thousand separator instead of thousand separator) like this: 1,000 -> 1000 10,000 -> 1,0000 1,000,000 ->100,0000 1,000,000,000 ->...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 40
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top