Ask Your Question

Custom Currency

asked 2020-01-29 04:01:04 +0200

Tilak gravatar image

Hi All

Could someone please advise me (or point to an answer) of how I could set a custom currency - in Calc - preferably as a default - to show;

positive numbers - in black, comma separator for thousands, point as decimal separator, 2 decimal places - as - Rs. 1,234.56

negative numbers - as above but all in RED with a minus (-) in front of the number - ie - Rs. -1,234.56

If in the answer you could mention how to display negative values in brackets () - the one answer may help other too.

Thanks very much

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-01-29 08:48:23 +0200

m.a.riosv gravatar image

Please take a look Number format codes With [Ctrl+1] Menu/Format/Cells on tab 'Numbers' select currency number you like, you can add "(" and ")" before and after of the negative number like:
#.##0,00 [$€-C0A];[RED]"("-#.##0,00 [$€-C0A]")" image description

edit flag offensive delete link more


May be you would need to do some changes in Tools - Options… - Language Settings - Languages.

LeroyG gravatar imageLeroyG ( 2020-07-28 02:19:05 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-29 04:01:04 +0200

Seen: 234 times

Last updated: Jan 29 '20