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 réponses

dobo69 Posted messages 1593 Registration date   Status Membre 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
Yumiz
 
Thank youuuuuuuuuuuuuuuuuuu!
0
supercoco
 
It's working!! Thank you very much !!!!!

Good evening
2