Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#### in cell instead of date
I changed the column widths in a page and now when I try to enter a date it brings up #### in the cell. How do I get rid of this? I tried the format to date and a couple of different date configurations to no avail. HELP! I have tons of data to enter. ksmith2051 -- ksmith2051 ------------------------------------------------------------------------ ksmith2051's Profile: http://www.excelforum.com/member.php...o&userid=34895 View this thread: http://www.excelforum.com/showthread...hreadid=546353 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#### in cell instead of date
Just means the column width is to small.
-- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "ksmith2051" wrote: | | I changed the column widths in a page and now when I try to enter a date | it brings up #### in the cell. How do I get rid of this? I tried the | format to date and a couple of different date configurations to no | avail. HELP! I have tons of data to enter. | | ksmith2051 | | | -- | ksmith2051 | ------------------------------------------------------------------------ | ksmith2051's Profile: http://www.excelforum.com/member.php...o&userid=34895 | View this thread: http://www.excelforum.com/showthread...hreadid=546353 | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#### in cell instead of date
This problem occurs because the column width you have designated for the column is too small. you could extend the column width for the column to show the true values or do a best-fit adjustment by double clicking the right hand side border of the column header for the column which contains the date values. If you are adjusting this document's column width so that it prints out on a single A4 sheet, what you could do is to use a small font for the data content or simply set the page setup to landscape format. -- KellTainer ------------------------------------------------------------------------ KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322 View this thread: http://www.excelforum.com/showthread...hreadid=546353 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#### in cell instead of date
Thanks for your advice!!!!! Problem solved Ksmith2051 -- ksmith2051 ------------------------------------------------------------------------ ksmith2051's Profile: http://www.excelforum.com/member.php...o&userid=34895 View this thread: http://www.excelforum.com/showthread...hreadid=546353 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
#### in cell instead of date
You're welcome.
-- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "ksmith2051" wrote: | Thanks for your advice!!!!! | Problem solved | Ksmith2051 | | | -- | ksmith2051 | ------------------------------------------------------------------------ | ksmith2051's Profile: http://www.excelforum.com/member.php...o&userid=34895 | View this thread: http://www.excelforum.com/showthread...hreadid=546353 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run a macro in a locked cell | Excel Discussion (Misc queries) | |||
Excel 97 SR-1 / Set date in a cell-have day track in another cell | Excel Discussion (Misc queries) | |||
HELP - Date Range In 1 Cell Calculation | Excel Worksheet Functions | |||
Need to use IF formula with a Date cell | Excel Worksheet Functions | |||
Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) |