Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I type a date (1/05) in a cell, press enter, it reads ####.Why?
Probably the cell is not wide enough.
-- Kind regards, Niek Otten Microsoft MVP - Excel "KIWI" wrote in message ... | 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I type a date (1/05) in a cell, press enter, it reads ####.Why?
On Mon, 5 Feb 2007 05:37:00 -0800, KIWI
wrote: 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 The cell is probably too narrow. The solutions include: 1. Making the cell wider. You can do that by dragging the right column edge at the top of the column to the right, making the whole column wider. 2. Changing the font size in that cell so that more characters can fit into the cell. Select the call and change the number in the point size field. 3. Changing the format of the data so that it is more compact. If the date is being displayed as "February 3, 2007", change it to "2/03/07" or just "2/03". Right click on the cell and select Format Cells. Then select the appropriate Date formatting. -- Running Excel 2000 SP-3 on Windows 2000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
Automaticaly Enter Date in selected Cell | Excel Discussion (Misc queries) | |||
Cell References | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions |