Forum Discussion

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 som...

MVP

Mar 13, 2020

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.

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
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.
- time2sit
  Copper Contributor
  Mar 13, 2020
  It was and is on 'General'. But changes with each new cell. With your feedback I'm changing it now with each tab.
  
  But do I have to do that? Set the format for each and every cell? Cause that'll take forever. Also what do I need to do to get the font size to stay on 12? It changes to 14 with each tab or manually move to a new cell or row.
  
  ExcelExciting
  - time2sit
    Copper Contributor
    Mar 13, 2020
    ... if possible can someone show or tell me again how to do the text so it wraps to the next line vs my just tabbing to a new row with info that goes with the row above? You can see what I did in the screen shot above. "Emails. Then searching thru emails to find info J said she sent to me for .....

Resources