Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


excel date entry

  • Please log in to reply
5 replies to this topic

#1 yogibear67


  • Members
  • 2 posts
  • Local time:01:39 PM

Posted 25 November 2010 - 11:00 PM

When I enter a date in a certain field all I get are number signs Why?

Edited by Orange Blossom, 26 November 2010 - 03:26 PM.
Moved to Business apps from Intros. ~ OB

BC AdBot (Login to Remove)


#2 edeekremer


  • Members
  • 45 posts
  • Local time:01:39 PM

Posted 25 November 2010 - 11:09 PM

You do not have the field format set right

#3 edeekremer


  • Members
  • 45 posts
  • Local time:01:39 PM

Posted 28 November 2010 - 12:57 PM

Ok Yogi sorry for short reply the other day was headed out are you still having Problems with this?

#4 Eyesee


    Bleepin Teck Shop

  • BC Advisor
  • 3,545 posts
  • Gender:Male
  • Location:In the middle of Kansas
  • Local time:04:39 PM

Posted 29 November 2010 - 07:19 PM

Right click on the cell, column or range
Go to format cells
Select date and the formatting you would like
click ok

May vary but should be similar in different versions of Excel
In the beginning there was the command line.

#5 Galadriel


    Bleepin Elf

  • Malware Response Team
  • 2,753 posts
  • Gender:Female
  • Location:Missouri, USA
  • Local time:03:39 PM

Posted 29 November 2010 - 09:28 PM

Sometimes, it shows the pound sign (#) because the column is too narrow to contain the whole entry. Try expanding it. If you move your cursor to that field, do you see the date in the function text box?

If it looks like it does in this screenshot, you need to expand the column width. The blue arrow shows you where to click and drag (or alternatively, double click on it to auto-adjust size).

Posted Image
I cemna prestar aen. Han mathon ne nen. Han mathon ne chae. A han noston ne 'wilith. - Galadriel
'The avatar is changed; I can feel it in the water, I can feel it in the earth, I can smell it in the air.'

Phear teh ceiling cat, for he is roofkittehd! - Basement Cat

I'm a Bleeping Folder, are you? - Join BC in the fight against diseases - Click here
Become a BleepingComputer fan: Facebook

#6 Geoffc


  • Members
  • 89 posts
  • Gender:Male
  • Location:Warragul, Australia
  • Local time:08:39 AM

Posted 07 December 2010 - 12:25 AM

So much good intentions; so little gratitude or feedback.

I wonder what yogibear67 will want next?

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users