| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date formula
I am trying to input a date into a read only file. The column will not allow
me to expand the column and of course i get ######## in the column. I will accempt 11/15/07, instead of 11/15/2007, but how to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date formula
Try forcing the date as Text. You can do this by preceding your entry with
an apostrophe. '11/15/07 The apostrophe will not show up in the cell. HTH, Elkar "pkcb113" wrote: I am trying to input a date into a read only file. The column will not allow me to expand the column and of course i get ######## in the column. I will accempt 11/15/07, instead of 11/15/2007, but how to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date formula
pkcb113 wrote:
I am trying to input a date into a read only file. The column will not allow me to expand the column and of course i get ######## in the column. I will accempt 11/15/07, instead of 11/15/2007, but how to do this? It's probably just because the column isn't wide enough to show the full date you require. Resize the column and it will show it properly. Regards, Ian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Linear Mode
