Forum Discussion
First Attempt at Spreadsheet from scratch, could use some help
Hi all,
I'm trying to create a spreadsheet and cannot for the life of me get the date to show (everything I've tried shows 44927 in the cell) or my formulas to show the totals of the formulas, they only show the formulas. Below are my product info and a snip of my spreadsheet. Any help would be appreciated. Thank you!
The picture is small but I have 19.41 in box F2 and 91.5 in H2. Formula in H2 is =SUM(F2,G2), Formula for I2 is =SUM(H2)*12, and formula for N2 is =SUM(I2)*0.02
RyanMarshall On the Formulas ribbon (i.e. menu) find this icon
and click it.
You accidentally turned on the switch that shows formulas rather than the results of these formulas.
That's also why you see 44927 rather than a data as that is the numerical value for January 1, 2023.
With regard to your other formulas, there is no need to use SUM everywhere. These will do just fine:
=F2+G2
=H2*12
=I2*0.02
RyanMarshall On the Formulas ribbon (i.e. menu) find this icon
and click it.
You accidentally turned on the switch that shows formulas rather than the results of these formulas.
That's also why you see 44927 rather than a data as that is the numerical value for January 1, 2023.
With regard to your other formulas, there is no need to use SUM everywhere. These will do just fine:
=F2+G2
=H2*12
=I2*0.02
Riny_van_Eekelen Perfect thank you!
