1/00/1900 in Excel 2007 Pivot Table
I have an Excel 2007 spreadsheet with both entered and calculated date columns.
The entered date cells with all blanks convert as blank in the Pivot table, however calculated cells with blanks ("") convert as 1/00/1900. How can I convert blank calculated
cells to a blank rather than this date in the Pivot table?
Solutions to the Problem 1/00/1900 in Excel 2007 Pivot Table
Thank you for your response However this did not resolve my question.
My questions was resolved by JustAnswers and was to Office button\Excel Options\Advanced\Display options for this worksheet,uncheck the box 'Show a zero in the cell
If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.
Recommended Method to Repair the Problem: 1/00/1900 in Excel 2007 Pivot Table:
How to Fix 1/00/1900 in Excel 2007 Pivot Table with SmartPCFixer?
1. You can Download SmartPCFixer here. Install it on your computer. When you open it, it will perform a scan.
2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.
3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed
Read More: Tech Support: 15-20 second delay when closing a window,How Can I Fix - 2003 Excel XLW file is now considered a \"picture file\" when opened in 2010 Excel?,Troubleshoot:32bit vista computer won't work with juno needs triedit.dll ??? Error,Troubleshooter of Error: 7 backup fails and gives error Ox81000037 (only the 1 error message),Solution to Error: 1) Macro in MS Excel 2007 not record 2) Macro developed in MS Excel 2003 cannot run in MS Excel 2007 version,2013 microsoft appcrash,15 talk radio stations coming through all at the same time,3 TB Hard drives,3rd Hard Drive not assigned drive letter although system recognizes it is there.,64 bit Windows 7 Ultimate side by side configuration error