+ Reply to Thread
Results 1 to 3 of 3

Numbers in cells overlapping to next cell

  1. #1
    Registered User
    Join Date
    06-07-2013
    Location
    Dorset, England
    MS-Off Ver
    Excel 365
    Posts
    5

    Numbers in cells overlapping to next cell

    numbers.jpg

    Hi all,

    Something weird happening to a lot of my spreadsheets over the last few days. Please see attached picture. This is part of a pivot table, but same happening in just normal data.

    The numbers in all the cells are overlapping to the next cell when they didn't use to. I have not changed any formats/fonts and as I mentioned, this is happening on a lot of different sheets.

    I am at a loss, can anyone help please?

    Thank you.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Numbers in cells overlapping to next cell

    Pictures are rarely any use and I'm unable to understand what you mean by overlapping numbers.

    Please upload the workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    06-07-2013
    Location
    Dorset, England
    MS-Off Ver
    Excel 365
    Posts
    5

    Re: Numbers in cells overlapping to next cell

    Thanks for the help and suggestions.

    I have uploaded a file which doesn't have quite such pronounced overlaps, but if you scroll down to the Totals row (68), you can see the final digit crosses over into the next cell - (Numbers)

    The 2nd file - example when I open up the spreadsheet, columns, G, H and I have digits overlapping into the next cell even though the cell width is plenty wide enough.

    I downloaded the attached files from this post and they opened up correctly with no overlapping!

    Below is a screenshot of how the example file looks when I open it in excel.

    I hope that helps better?
    Attached Images Attached Images
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combining Overlapping Dates between Unique ID & Identify Overlapping with Other Date Range
    By bihaequipinc in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 09-28-2021, 02:11 AM
  2. Replies: 0
    Last Post: 10-01-2020, 05:40 AM
  3. [SOLVED] Looking to populate "x" # of cells in a row with a reference cell w/o overlapping below.
    By Jonathan87 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2019, 12:43 AM
  4. Overlapping cells
    By samuel kelly in forum Excel General
    Replies: 3
    Last Post: 08-30-2016, 04:10 AM
  5. [SOLVED] Overlapping cells
    By Marlow212 in forum Excel General
    Replies: 2
    Last Post: 04-04-2014, 11:51 AM
  6. [SOLVED] VBA to Check overlapping numbers.
    By rjnewsome in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-18-2013, 09:55 PM
  7. Replies: 2
    Last Post: 06-25-2013, 04:31 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1