A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

##### Date in Excel



 
 
Thread Tools Display Modes
  #1  
Old October 9th, 2005, 10:46 PM
Mandy S
external usenet poster
 
Posts: n/a
Default ##### 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  
Old October 9th, 2005, 11:11 PM
Mandy S
external usenet poster
 
Posts: n/a
Default


"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  
Old October 9th, 2005, 11:31 PM
David Biddulph
external usenet poster
 
Posts: n/a
Default

"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  
Old October 9th, 2005, 11:49 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

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  
Old October 10th, 2005, 12:05 AM
Piranha
external usenet poster
 
Posts: n/a
Default


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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Date Format - users should be able to override it automatic. jamezog General Discussion 7 May 20th, 2010 02:45 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno General Discussion 2 June 13th, 2005 02:01 PM
Excel enters date as a text format Kane General Discussion 3 March 22nd, 2005 10:20 PM
Windows in Taskbar Chevy General Discussion 8 October 15th, 2004 03:57 PM
Excel 2000 date does not display date correctly General Discussion 4 June 29th, 2004 10:09 AM


All times are GMT +1. The time now is 04:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.