How to solve the Please Enter Valid Days or Wages for IP’s

                                                ENTER VALID DAYS AND WAGES OF IP'S

•       Check for formatting for values in Days / Wages column for these IP’s. There must be a difference between these ones and the other ones. Keep note of the small green symbol at top left of the cell, That sign is for “number stored as text” so you can convert them to text by selecting entire cells, 
• 
  
•       Go to DATA -> Text to Column -> Select “Delimited” -> Next -> Finish.
• 
  

   

•      Again upload excel sheet.