Forum Discussion
Excel automatically adding a date to a cell in which I want something else.
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.
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
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.
- ... 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 .....
time2sit To wrap text, select FORMAT in the top many, then alignment and then check the box "Wrap text".
Alternatively, find the wrap text icon on the HOME ribbon in the "Alignment" section and press it. It's the one at the top right.
With regard to the justification issue, try this. Select the entire worksheet and make sure that none of the left, center and right icons (the three icons at the bottom-left) are greyed. This turns all cells to have standard justification. I.e. text towards the left, dates and numbers to the right. Only use these buttons if you want to explicitly change this behaviour.
To check your default font, press Excel (next to the Apple sign at the top-left), then "Preferences..." and then the "General" icon in the Authoring section. Make sure that your default font and size are how you want them to be. This will then apply to any new workbook you open. In an existing workbook you may have to do similar steps as described above, i.e. "Select all" and choose the font and size you want for all cells in your sheet. This will get rid of cell formats that may have been set differently.
The above pictures were taken on the latest Excel version, but from what I remember, it looks similar on older versions.
