Forum Discussion
Solved
Date Series in a spreadsheet
I've entered a row of dates in the form mo/da/year from 1/1/2023 to 12/31/2023, but a number of the dates show symbols #######, yet when the cursor is placed over the cell the proper date (ie. 1/10/2...
- Gary_A_Tubbs,
I think you're in the wrong forum. This forum is specifically for technical questions/issues with Microsoft Project, a planning and scheduling application.
Nonetheless, values in Excel worksheets will show as ##### if the column width is insufficient for the value. The simple solution is to find the largest value. In your case that would probably be 12/31/2023 so adjust the column width for the whole series to be as wide as necessary to show 12/31/2023. If you place your cursor over the vertical column divider and double click, Excel will automatically expand the column width so the value shows.
John
Gary_A_Tubbs,
I think you're in the wrong forum. This forum is specifically for technical questions/issues with Microsoft Project, a planning and scheduling application.
Nonetheless, values in Excel worksheets will show as ##### if the column width is insufficient for the value. The simple solution is to find the largest value. In your case that would probably be 12/31/2023 so adjust the column width for the whole series to be as wide as necessary to show 12/31/2023. If you place your cursor over the vertical column divider and double click, Excel will automatically expand the column width so the value shows.
John
I think you're in the wrong forum. This forum is specifically for technical questions/issues with Microsoft Project, a planning and scheduling application.
Nonetheless, values in Excel worksheets will show as ##### if the column width is insufficient for the value. The simple solution is to find the largest value. In your case that would probably be 12/31/2023 so adjust the column width for the whole series to be as wide as necessary to show 12/31/2023. If you place your cursor over the vertical column divider and double click, Excel will automatically expand the column width so the value shows.
John
Your comment is Noted; Thanks, GT John-project
