Numbers automatically selects "date" format for cells.
Numbers automatically selects "date" format for certain cells.
I need "numbers".
I want to calculate simple interests due as a function of amount, interest rate and number of days.
When I input "number" format for the result cell and calculate amount*interest rate*number of days divided by 365 it always automatically shows something unwanted and formatted as "date". Moreover I am not able to change the automatic format ("date") into "number". How to get around this automatic selection?
Thanks in advance
UbiUbu
MacBook, iOS 9.2.1