professor-excel.com
Force Any Cell to Your Desired Format in Excel
Excel is very unpredictable when it comes to text/number formatting. Here is what you should do in order to force Excel to accept your desired format.