What are the allowed text when setting the cell types.  I see that 'Percent' changes the format to percentage.  What are the other cell type descriptions? I tried 'Number' but that didn't work.

  

• Moved by Lanlan HuangMicrosoft contingent staff 4 hours 43 minutes ago

Hi

This is the forum to discuss questions about Microsoft Excel (VSTO, VBA) develop. For your question is about features in Excel, I will move this question to TechNet forum for Excel

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

Best Regards,

Lan