From Zoho CRM, there is a button "Zoho Sheet View" that converts the current view into a spreadsheet.  One of my columns in CRM is Amount (a dollar value) but it converts those values to text in the spreadsheet.  Is there a simple way to convert text to a number rather than going to each cell and deleting the preceding single quote?

the same question applies to the date column.  All the dates are now preceded with a single quote - is there a simple way to convert these from text to dates?