Hello,
I'm trying to translate a date and time that comes in a format of MM DD and HOUR in three different columns, and with just four numbers for the time (ie 1000)
What I'd like to do is get all the information into a single cell that has the format
mm/dd hh:mm
I've tried using the RIGHT () and LEFT() commands to get the date information in, but it doesn't seem to allow me to format the cells where I've done the Right and Left commands. Is there someway I can get the information from these original cells, and still be able to format it correctly so when I plot, it will show the day and time?
thank you!
Erik
Bookmarks