Formatting numbers to display units

[rjplante]

I have a cell that needs to be recognized as a number, but which needs to have the units displayed. I know that I can do this with a custom number formatting pretty easy, but here is the part that requires VBA. If the value enetered is <= to 0.03, I need the cell to display "<0.03EU/mL". If it is greater than 0.03, I need it to display the units entered with the units after "0.5EU/mL". How do I do this with VBA using the worksheet.change feature?

Thanks

 

[lenze]

How are the numbers entered?? By user or by formula?

lenze

 

[rjplante]

Numbers are entered by the user.

 

[lenze]

Did you try this custom format?

[<0.03]"<0.03EU/mL";#"EU/mL"

lenze

 

[rjplante]

Thanks it works great!