Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Stone Ridge, New York, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Numbers/Dates - No Spillover (Excel 2003)

    I read a post that included this piece of information:

    "In the first place, the "overspill" only occurs for text values, not for numbers and for dates."

    Is there any way to get the "overspill" to function for numbers and dates? I have a form I'm trying to design. It has to be in Excel and the numbers and dates are coming in from code so I can't merge the cells. But there is no way to design this intricate form without either the "spillover" for numbers and dates, or using merged cells. I have to have one or the other. Any ideas on what I can do?

    Thanks in advance,

    Sherry

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Numbers/Dates - No Spillover (Excel 2003)

    As the post said, you can only overspill text, so you would have to change the format of the cell(s) to text before entering the number/date. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Stone Ridge, New York, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbers/Dates - No Spillover (Excel 2003)

    Turns out I can merge the cells and still have the data come in properly via the code. That solves my problem.

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •