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