Ubuntu
openoffice.org package

Number Format - Negative Numbers

Asked by srikumar

The negative numbers in OpenOffice Spreadsheet is shown with a minus sign (-) ; which does not show up well when printed in black and white. - I guess colour printing would show the negative number in red.

Is it possible to show negative numbers within brackets () - for eg: so that 100 - 120 = (20) which makes it quite visible in a printed document rather that -20.

Any suggestions ?
thank you
srikumar

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Abi ^-^
Solved:
Last query:
Last reply:
Revision history for this message
Best Abi ^-^ (abiyasa-eka) said : 		#1

Go to Format - Cells - Tab Number

Click Number in category

Look at Format code

By default it is write 0

Change the number so it looks like

0;(0)

The first number is a format of positive number ...
And the second number is a format of negative number ...

Revision history for this message
Abi ^-^ (abiyasa-eka) said : 		#2

Hello

I'm sorry, When you click Number in category, look at Format code

by default it contents is Standard (or whatever)

You just need to change the contents so it looks like

0;(0)

Thank You ^-^

Revision history for this message
srikumar (ssrikumar) said : 		#3

Thanks Abi ^-^, that solved my question.

Revision history for this message
srikumar (ssrikumar) said : 		#4

the format was changed to
#,###.00;(#,###.00)
and it woorks
thank you