Forum Discussion

time2sit's avatar
time2sit
Copper Contributor
Mar 13, 2020

Excel automatically adding a date to a cell in which I want something else.

In some of my excel cells where I put 'hours worked' and in the next one 'hours billed' it auto changes to some weird date. When I delete and again try to add my hours it just again changes it to some date.

 

Also it will not hold the font size to what I want and keeps auto changing it to 14, when I want 12.

 

I have a MacBook Air using Office Home & Student 2016

excel

6 Replies

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Mar 13, 2020

    HI time2sit 

     

    could you please share the screen shot of you date upon entering the data 

     

    seems to be formatting issue.

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer.

    • time2sit's avatar
      time2sit
      Copper Contributor
      Mar 13, 2020

       

      TY, Faraz. I'm also having problems with wrapping text onto the next line as you can see. And my .25 of an hour won't go to the far right of the cell as in the others.

      ExcelExciting 

      • ExcelExciting's avatar
        ExcelExciting
        MVP
        Mar 13, 2020

        Hi time2sit 

         

        It is formatting issue, make sure your columns is not as "Text" format, change it "General" or "Number" format before entering the data 👍🏻😃 

         

         

        Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

        If you find the above solution resolved your query don't forget mark as Official Answer.

Resources