+ Reply to Thread
Results 1 to 2 of 2

Some Cells look different when spreadsheet is viewed by others

  1. #1
    Registered User
    Join Date
    11-07-2014
    Location
    Grenada
    MS-Off Ver
    MS Office for Mac 2011
    Posts
    1

    Some Cells look different when spreadsheet is viewed by others

    I have a very simple one-page spreadsheet, with 8 columns. Only one column is formatted as "Accounting" and contains monetary values from $175.00 to $6,000.00. The sheet looks fine when I finish with it, but when my boss looks at it, some of the monetary cells contain #####. I thought this might be caused by a column being too narrow to show all the information, but on the most recent occasion of this, the only cells with the #### signs were the lowest dollar amounts (in the hundreds, rather than thousands). I'm not sure what's causing this, but I'd like to get it resolved so my boss can read the full sheet.

    In the last instance, I went in and made the font smaller for those 3 cells and that corrected it. But it just seems like an odd way to fix this.

    There are no calculations in the cells in question... only numeric values.

    Does anyone have any suggestions?

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Some Cells look different when spreadsheet is viewed by others

    If making the font smaller fixed it that would suggest that the column was too narrow.
    Remember what the dormouse said
    Feed your head

+ 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. Update spreadsheet as it's being viewed by others?
    By JP Romano in forum Excel General
    Replies: 4
    Last Post: 09-18-2009, 03:00 PM
  2. Protect Cells So Contents Can't Be Viewed
    By AK262007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2008, 06:45 AM
  3. Replies: 1
    Last Post: 02-09-2006, 01:45 PM
  4. Replies: 0
    Last Post: 03-15-2005, 11:06 AM
  5. Replies: 1
    Last Post: 02-10-2005, 04:06 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