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....
Put Data into a UserForm
Tutorial: How to take data from Excel and put it into a UserForm. This is useful when you use a form...

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.