Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Not enough room to enter dates

Greetings,

Im using Excel 2003 and im in the process of basically setting up a works
schedule for the remainder of 2008. Basically, from cell A2 downwards is a
list of activities/jobs and from cell B2 along is a list of dates, ie
01/02/08, 02/02/08 etc.

I want every day this year to run left to right starting from 01/01/08 and
ending 31/12/2008 but there are not enough cell to contain all of the dates,
the last cell is IV. Is there any way i can fit the dates in by adding more
cells?

Any help would be stunning.

Cheers
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default Not enough room to enter dates

Hi
XL2003 and earlier versions have a limit of 256 columns IV being the last.
You cannot change this value.
XL2007 has 16,000 + columns

--
Regards
Roger Govier

"CaptainCrumpet" wrote in message
...
Greetings,

Im using Excel 2003 and im in the process of basically setting up a works
schedule for the remainder of 2008. Basically, from cell A2 downwards is a
list of activities/jobs and from cell B2 along is a list of dates, ie
01/02/08, 02/02/08 etc.

I want every day this year to run left to right starting from 01/01/08 and
ending 31/12/2008 but there are not enough cell to contain all of the
dates,
the last cell is IV. Is there any way i can fit the dates in by adding
more
cells?

Any help would be stunning.

Cheers


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Not enough room to enter dates

Cheers Roger, we only have 2003 version here so guess i will have to come up
with another design. Thanks for your help though squire!

Cheers
The Captain

"Roger Govier" wrote:

Hi
XL2003 and earlier versions have a limit of 256 columns IV being the last.
You cannot change this value.
XL2007 has 16,000 + columns

--
Regards
Roger Govier

"CaptainCrumpet" wrote in message
...
Greetings,

Im using Excel 2003 and im in the process of basically setting up a works
schedule for the remainder of 2008. Basically, from cell A2 downwards is a
list of activities/jobs and from cell B2 along is a list of dates, ie
01/02/08, 02/02/08 etc.

I want every day this year to run left to right starting from 01/01/08 and
ending 31/12/2008 but there are not enough cell to contain all of the
dates,
the last cell is IV. Is there any way i can fit the dates in by adding
more
cells?

Any help would be stunning.

Cheers



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to Enter Dates Jacq Excel Discussion (Misc queries) 5 March 12th 07 09:14 PM
Enter 2 dates in same excel cell m_a_turcotte Excel Discussion (Misc queries) 4 May 16th 06 08:15 PM
Enter dates and return availability Statler Excel Worksheet Functions 2 January 30th 06 10:47 AM
How to NOT enter dates? glitzernes New Users to Excel 2 June 9th 05 04:22 PM
How to enter dates? dreidman New Users to Excel 2 April 27th 05 03:36 AM


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"