View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terry Winter Terry Winter is offline
external usenet poster
 
Posts: 1
Default Formatting columns with either a date OR a numerical figure

I need to be able to manipulate data, so that I have 1 column with either a
Date field, in dd/mm/yyyy format of a number to zero decimal points. I have
tried formatting this column to text and linking the column to two other
columns that are formatted in either date or numbers, but is simply pulls
back the date in the standard numerical value. I have a standard =If
formulae, which pulls back the data. Is there an precursor that can be added
to the IF statement that will pull back the data in the correct format...