Stop Auto Formatting of Numbers into Date in Microsoft Excel

Whenever you eneter numbers separated by a hyphen in Microsoft Excel, it automatically converts that data into date format. Suppose you type "2-2" in Excel it becomes "02-Feb" automatically, so to prevent this automatic formatting of numbers into date in Excel follow simple steps below. Method-1 Step-1 Select entire cells of a Workbook in Excel [...]

How to Set Password on Word Document

Microsoft Office applications Word, Excel and PowerPoint help users to prevent the files from unauthorized access by providing the feature of “Encrypt with Password”, which allows users to make their files password protected. Here you can see how to set and remove password: Word 2010 document Word 2007 document Set a Password to document in [...]

Advertisement

How to Save Excel 2010 File as PDF

Transferring documents in PDF file format is very common, Converting Excel document to PDF file and sharing with your customers in protected mode, your customer can't change it and its is in the same layout that you have created in Excel. Microsoft Excel also gives an option to save Excel .xslx files as PDF. follow [...]