How do i format a cell to accept only data that meets specific requirements
M mallipeddisunil New Member Sep 21, 2009 #1 How do i format a cell to accept only data that meets specific requirements
G govi Member Sep 21, 2009 #3 See this post by PHD himself: http://chandoo.org/wp/2008/08/07/excel-add-drop-down-list/
M mallipeddisunil New Member Sep 23, 2009 #4 actually my cell format must contain _ _:_ _:_ _ like this by enter only values(ie letters or numbers) in blanks automatically cell must be A9:05:05
actually my cell format must contain _ _:_ _:_ _ like this by enter only values(ie letters or numbers) in blanks automatically cell must be A9:05:05
K keymaster New Member Sep 24, 2009 #5 If all of them are numbers, you can use the 00:00:00 as format code. But if it is alpha numeric, I dont know how you can control the format at character level. It might be a good idea to split the input to 3 cells.. ?
If all of them are numbers, you can use the 00:00:00 as format code. But if it is alpha numeric, I dont know how you can control the format at character level. It might be a good idea to split the input to 3 cells.. ?
