Excel Magic Trick 1144

Top 3 TEXT Function uses ISO Date to Date , Text Time To Time , Date To Month

DESCRIPTION

See how to:
(00:07) Text Function and Custom Number Formatting
(01:08) Convert Serial Number Date To Month Name Text: TEXT function with Custom Number Formatting “mmm” so we can have a column of three letter abbreviation Month Names.
(02:40) Convert Text Time To Serial Number Time: TEXT function with Custom Number Formatting “00\:00” so we can have a column of Serial Number Time Values.
(04:13) Convert Text Number back to a Number: Any math operation.
(05:03) Convert ISO Date to Serial Number Date: TEXT function with Custom Number Formatting “0000-00-00” so we can have a column of Serial Number Date Values.
(07:40) Use the Converted data: PivotTable For Total Calls, where we 1) Group By Date, 2) Show in Tabular Form, 3) add Number Formatting and Name Sheet.

WORKBOOKS