| View previous topic :: View next topic |
| Author |
Message |
Grandis
OOo Advocate
Joined: 05 Mar 2007
Posts: 232
Location: Norway
|
 Posted: Mon Aug 04, 2008 7:24 am Post subject: Format code - other separator than thousands [solved] |
 |
|
Hi. I'm using OOo V2.41 on winXP.
I have some cells containing 8 digit number. I want those numbers being separatet like this:
123 45 678 - But I cannot get it right.
When I try a format code like "#00 00 000" I still just get the usual Thousands separator. I don't make it looks like shown above.
The numbers of the cells will always be exactly 8 digits.
_________________
Windows XP sp2
Last edited by Grandis on Mon Aug 04, 2008 2:28 pm; edited 1 time in total |
|
| Back to top |
|
 |
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Mon Aug 04, 2008 7:40 am Post subject: |
|
|
A single space anywhere "above" the decimal point in the format code means "use thousands separator". You can, however, insert any character anywhere in the format by quoting it.
So instead of 000 00 000, enter 000" "00" "000 |
|
| Back to top |
|
|
|
