New answers tagged formatting
0
If you switch off grid do you still see the line? To switch it off, just click outside the lines and untick Grid on the right.
Regards,
0
As you've mentioned the site doesn't seem to have a spreadsheet export option, but we can quite easily convert the html export to a spreadsheet or insert it into an email.
You can create a .xls file, edit this file with a text editor and copy paste the html code from the export in this file.
If you want to put it in an email you could save the html export to ...
0
To display fractions in the dropdown, you need to convert the decimal/formatted value to a text value.
For example:
=text(A1:A5,"# ???/???")
If the resulting dropdown value is to be used in a calculation, then you need to convert it back to a number.
For example:
=left(B10,search("/",B10)-1)/right(B10,len(B10)-search("/",B10))
...
Top 50 recent answers are included
