i have change format of cell euros based on value. if between 1 , -1 have 3 decimal places. else, have one. euro symbol needs come before number. i'm having trouble getting euro sign show , having zeros after decimal show numbers such 23, appear 23.0 or .9 should change .900.
try (replacing cellrow , cellcolumn desired row , column cell):
if cells(cellrow,cellcolumn).value >= -1 , cells(cellrow,cellcolumn).value <= 1 cells(cellrow,cellcolumn).numberformat = "[$€-2] #,##0.000" else cells(cellrow,cellcolumn).numberformat = "[$€-2] #,##0.0" end if 