View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
whitepa05 whitepa05 is offline
external usenet poster
 
Posts: 1
Default dynamic number format

I have a vlookup formula that will return different data based on a user
input. The data will either be a percentage or an integer. How can I
conditionally format the cell so that the number is formatted properly, or
that the vlookup returns the value and formats?