ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cannot type in cells, time format 12:00am (https://www.excelbanter.com/excel-discussion-misc-queries/181480-cannot-type-cells-time-format-12-00am.html)

monkeyboy

cannot type in cells, time format 12:00am
 
I have a slight problem with excel. I downloaded a timetable template,
however instead of putting times in the cells I want to put peoples names.
Everytime I try and type in a cell it asks for time format 12:00am. How can
I change this so I can type in text

Gary''s Student

cannot type in cells, time format 12:00am
 
Check to see if the cells have Data Validation. If they have Validation,
then turn it off.
--
Gary''s Student - gsnu200775


"monkeyboy" wrote:

I have a slight problem with excel. I downloaded a timetable template,
however instead of putting times in the cells I want to put peoples names.
Everytime I try and type in a cell it asks for time format 12:00am. How can
I change this so I can type in text



All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com