OPEN-OFFICE: separate hundreds from thousands

supercoco -  
 Yumiz -
Hello,
My question is simple: I would like to know how to separate hundreds from thousands in Open Office spreadsheet because I need it for accounting.
For example, for: 10000 I would like the spreadsheet to write it as 10 000
or 100000 so that the spreadsheet writes it as 100 000.
(I tried putting a space but it combines all the numbers when I press enter)

Thank you for your answers !!
Configuration: Windows Vista Firefox 3.0.15

2 answers

  1. dobo69 Posted messages 1593 Registration date   Status Member Last intervention   835
     
    Good evening,

    go to format -> cell -> number: check "thousands separator"

    in this dialog box, it is possible to define all the desired display formats.

    --
    If you need anything, just ask me.
    14
    1. Yumiz
       
      Thank youuuuuuuuuuuuuuuuuuu!
      0
  2. supercoco
     
    It's working!! Thank you very much !!!!!

    Good evening
    2