format datetime

  1. W

    keeping a custom format date

    I have columns of various types which need different formats. I'm aware Excel treats dates as a number, but I have a column which has dates as custom type in the format "M/D/YYYY H:MM". If I find a cell like this I need to keep the date. I've used a case statement for the other formatting & it...
  2. J

    How to change format from General to Date/Time?

    I'm using Excel-2007. I exported data from a windows application for analysis/calculations and one of the columns is a time stamp for various transactions. I'll call it the TransTime column. The format of the resultant exported data TransTime column is GENERAL and below is a sample data...

Some videos you may like

This Week's Hot Topics