View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KIWI KIWI is offline
external usenet poster
 
Posts: 10
Default I type a date (1/05) in a cell, press enter, it reads ####.Why?

I'm entering data inMicrosoft Excel and am fairly new to Excel. I'm entering
dates in cells in a worksheet and typred in a date and pressed enter and all
it will do is read #####. Why does it do this and how do I get the computer
to recognise the actual numbers of the date I entered? erg