1. I have a four digit number that needs to be changed into one cell, as hh:mm. I know it has something to do with the HOUR and MINUTE command but I don't know what.
2. I have a date that I need to show the day of week. I also know that the end of the command is "ddd", but I don't know the rest of it.
I did both of these a looooong time ago.
2. I have a date that I need to show the day of week. I also know that the end of the command is "ddd", but I don't know the rest of it.
I did both of these a looooong time ago.