Excel Forum
Similar Content
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Count the Number of Cells that Contain Specific Text in Excel
Tutorial: How to count the number of cells that contain specific text within a spreadsheet in Excel....
Convert Time to Decimal - Hours, Minutes, Seconds
Tutorial: Easily convert time to decimal format so that 9:15 AM or 9:15 will become 9.25, which mean...

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.