Excel Forum

Excel Magic Trick 257 Convert Dates as Text to Dates As No.

Dates As text will cause problems in a Pivot Table (PivotTable). See how to convert Dates as Text to Dates As Numbers so that you can group dates by month and year in a Pivot Table. See how to copy the number Zero and then Paste Special Operation Add to covert the dates as text to dates as numbers.

Also see this related video:

Excel Magic Trick #25: Trouble With Numbers Entered As Text

Got a Question? Ask it Here in the Forum.