Forum Discussion
Avionics_guy99
Jan 01, 2019Copper Contributor
Errors in spreadsheet
My dates are 5 numbers and cannot change them. My dollar amounts will not add. The sum formula does nothing. How can you tell if a spreadsheet is locked?? It almost acts like it is .. I have sw...
Avionics_guy99
Jan 02, 2019Copper Contributor
Found the comment mentioning the date function is made in numbers from 1 (Jan 1 1900) to what ever the current date is and using the Format Cells function to convert the data but it does not work. anyone with a better understanding of this please help... help.