Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format cells, custom type, delete dan Excel Discussion (Misc queries) 1 October 26th 06 07:39 PM
Adding new 'Type' to Format->Number->Time->Type Chip Pearson Excel Discussion (Misc queries) 5 September 26th 05 08:45 PM
Time formula 0600 = 11:00AM Aashish Excel Discussion (Misc queries) 1 March 24th 05 04:43 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM


All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"