[Solved] formatting numbers

Discuss the spreadsheet application
Post Reply
jaycee6828
Posts: 159
Joined: Mon May 05, 2008 10:16 am

[Solved] formatting numbers

Post by jaycee6828 »

Hi All,

I have searched but cannot find anything on this rather surprisingly.

How do I format a number so that it has a '+' or a '-' in front of it depending on if it is positive or negative.

It is easy to put a '-' in front of negative numbers I know but I can't seem to find anywhere to do the same for positive numbers.
Last edited by thomasjk on Wed May 28, 2014 4:29 pm, edited 1 time in total.
Reason: Mark thread [Solved] and add green checkmark
Open Office 3.4.1 on Ms Windows 7
User avatar
karolus
Volunteer
Posts: 1242
Joined: Sat Jul 02, 2011 9:47 am

Re: formatting numbers

Post by karolus »

Hallo

→→→numberfomatcode +0;-0;0

Karolus
Libreoffice 25.2… on Debian 13 (trixie) (on RaspberryPI5)
Libreoffice 25.8… flatpak on Debian 13 (trixie) (on RaspberryPI5)
jaycee6828
Posts: 159
Joined: Mon May 05, 2008 10:16 am

Re: formatting numbers

Post by jaycee6828 »

Thanks Karolus - easy when you know how!!
Open Office 3.4.1 on Ms Windows 7
Post Reply