| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date
i have a spreadsheet in read only and i am not allowed to change the column
size. I need to show 11/15/2007, however the column is too small for that, so 11/15/07 will not work. How can I change the setup to allow a 2 digit year? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date
Read only should not prevent you from changing column widths or anything else.
You just won't be able to save those settings. Perhaps you mean the sheet is "protected"? ToolsProtectionUnprotect Sheet. You may have to provide a password. Gord Dibben MS Excel MVP On Mon, 3 Dec 2007 13:14:29 -0800, pkcb113 wrote: i have a spreadsheet in read only and i am not allowed to change the column size. I need to show 11/15/2007, however the column is too small for that, so 11/15/07 will not work. How can I change the setup to allow a 2 digit year? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
