Date Time
I have several cells that different Date and Time have to be entered by
several different people, my problem is that I can not seem to get everyone to enter the date and time the same way, some of them will put the date first and some the date second, some use dashes and some backslashes and so on. How can I set the cell to show something like _ _ /_ _/_ _ _ _ _ _ : _ _ . I have this format in my ACCESS but how do I get it in EXCEL. |
Date Time
tankerman,
I selected- Format, Cells, Date Select 3/14/01 13:30. When I entered a time then date, it put it in the way I selected it. So you will have to copy the format to all the cells that you want the date and time the way you need for Access. HTH :-) "tankerman" wrote: I have several cells that different Date and Time have to be entered by several different people, my problem is that I can not seem to get everyone to enter the date and time the same way, some of them will put the date first and some the date second, some use dashes and some backslashes and so on. How can I set the cell to show something like _ _ /_ _/_ _ _ _ _ _ : _ _ . I have this format in my ACCESS but how do I get it in EXCEL. |
Date Time
Custom Format
mm/dd/yyyy HH:mm the HH: makes it 24 hour clock, hh: AM or PM. it will need to be pasted in cell then filled down for entire column. hth Lou "FloMM2" wrote: tankerman, I selected- Format, Cells, Date Select 3/14/01 13:30. When I entered a time then date, it put it in the way I selected it. So you will have to copy the format to all the cells that you want the date and time the way you need for Access. HTH :-) "tankerman" wrote: I have several cells that different Date and Time have to be entered by several different people, my problem is that I can not seem to get everyone to enter the date and time the same way, some of them will put the date first and some the date second, some use dashes and some backslashes and so on. How can I set the cell to show something like _ _ /_ _/_ _ _ _ _ _ : _ _ . I have this format in my ACCESS but how do I get it in EXCEL. |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com