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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.