custom format

[Access Beginner]

Hi all,

I have a custom format which will display millions as $2.5M and thousands as $249.9K. these values will always be above $100,000 and got up to a couple hundred million. However there are some newly created regions where data will no exist for a particular period and I have put an iferror around my vlookup and as a result the chart that this range is based off returns a zero. I have a custom format which will not display 0 in my chart, but I cant combine the two custom formats. Is it possible?

#,##0;-#,##0;;

[>=1000000] $#,##0.0,,"M";[>0] $#,##0.0,"K";

 

[Access Beginner]

Hi,

After trial and error it appears as it was as simple as

[>=1000000] $#,##0.00,,"M";[>0] $#,##0.0,"K";;

And here I was trying to combine the two.

Thanks if you had a look anyway