Home |
Search |
Today's Posts |
#1
|
|||
|
|||
##### Date in Excel
Please can anyone help me.
I Microsoft Office XP I had a very long list (about two thousand entries). Each entry had a date in column B Before I reformatted my PC I saved the document. When I put it back on my PC after the format all the dates in column B have changed to #######. If I point the mouse curser over each entry it shows the original date Can anyone PLEASE tell me is there a way to get thses dates back Many many thanks Mandy x |
#2
|
|||
|
|||
"Mandy S" wrote in message ... Please can anyone help me. I Microsoft Office XP I had a very long list (about two thousand entries). Each entry had a date in column B Before I reformatted my PC I saved the document. When I put it back on my PC after the format all the dates in column B have changed to #######. If I point the mouse curser over each entry it shows the original date Can anyone PLEASE tell me is there a way to get thses dates back Many many thanks Mandy x Please ignore, I was being a dumb blonde |
#3
|
|||
|
|||
"Mandy S" wrote in message
... Please can anyone help me. I Microsoft Office XP I had a very long list (about two thousand entries). Each entry had a date in column B Before I reformatted my PC I saved the document. When I put it back on my PC after the format all the dates in column B have changed to #######. If I point the mouse curser over each entry it shows the original date Can anyone PLEASE tell me is there a way to get thses dates back Try increasing the column width (for example, Format/ Column/ Autofit selection). -- David Biddulph |
#4
|
|||
|
|||
Mandy -
###### usually means the cell isn't wide enough to display the value in the selected number format. Double click on the line between this column's header and the header to the right, and the column will autosize to display the data properly. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Mandy S wrote: Please can anyone help me. I Microsoft Office XP I had a very long list (about two thousand entries). Each entry had a date in column B Before I reformatted my PC I saved the document. When I put it back on my PC after the format all the dates in column B have changed to #######. If I point the mouse curser over each entry it shows the original date Can anyone PLEASE tell me is there a way to get thses dates back Many many thanks Mandy x |
#5
|
|||
|
|||
Hi Mandy, Try widening your column, or highlight the column and go to Format, Column, AutoFitSelection. Dave Mandy S Wrote: Please can anyone help me. I Microsoft Office XP I had a very long list (about two thousand entries). Each entry had a date in column B Before I reformatted my PC I saved the document. When I put it back on my PC after the format all the dates in column B have changed to #######. If I point the mouse curser over each entry it shows the original date Can anyone PLEASE tell me is there a way to get thses dates back Many many thanks Mandy x -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=474630 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
today's date in excel | Excel Discussion (Misc queries) | |||
Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
Excel formula with date constraints | Excel Discussion (Misc queries) | |||
In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
Excel 2002 date formulas problem | Excel Worksheet Functions |