Macro VBA number formatting

[andyspa]

Hello!

I have this number formattin, which doesn't work for negative numbers. Anyone can can write a macro for me in order to make it possible?

[>=1000000] € #,##0.0,,"M";[<1000000] € #,##0.0,"K";General

Thanks million in advance!

Cheers,
andy

 

[Jeffrey Mahoney]

I used a Conditional formatting to solve the issue

Brown Bag Lunch Ideas.xlsm
	M	N
25	Formatted	Value
26	€ 1.3M	1254789
27	-€ 2.1M	-2148725
28	€ 0.0	0
29	€ 145.8K	145777
30	-€ 895.0K	-895000
Number Formatting

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
M26:M30	Expression	=M26<=0	text	NO

A view of the Conditional Formatting

 

[andyspa]

Thanks a lot Jeffrey! Is there a way to move the "-" before the numbers instead of the euro symbol?

 

[Jeffrey Mahoney]

You should have tried playing around with the number formatting. You can't break anything
[<=-1000000]€* -#,##0.0,,"M";[<=-1000]€* -#,##0.0,"K";€* 0.0