I currently see this premade
_(* #.##0,00_);_(* (#.##0,00);_(* "-"??_);_(@_)
This makes all negatives be (25.111,50) and all 0 be -
I still need 0's to be -, but I need negatives to show as -25.111,50
I currently see this premade
_(* #.##0,00_);_(* (#.##0,00);_(* "-"??_);_(@_)
This makes all negatives be (25.111,50) and all 0 be -
I still need 0's to be -, but I need negatives to show as -25.111,50
Help file for creating number format codes: https://support.office.com/en-us/art...2-09fab54be7f4
It should be as easy as removing the parentheses from the negative format section and adding hyphen/minus sign "-" to the format code. _(* -#.##0,00
Originally Posted by shg
Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks