Forum Discussion

RyanMarshall's avatar
RyanMarshall
Copper Contributor
May 23, 2023
Solved

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 ...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 23, 2023

    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's avatar
Riny_van_Eekelen
Platinum Contributor
May 23, 2023

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

Resources