Hi all,

I have a cell with a drop down menu in which a user chooses what unit they are working in.
Hours, Days or Weeks.

Then I have another cell in which the user enters a number.

I want the number entered to be automatically formatted according to the unit specified by the user.

Eg.

Unit Number

Hours 8 Hours (User entered only the number 8)
Days 8 Days (User entered only the number 8)
Weeks 10 Weeks (user entered only the number 10)

Your help is much appreciated.

Cheers.