Cell Display Issue

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I have a spreadsheet that I created in Excel 2007 (windows) and am using in Excel 2008 Mac.  I cannot get the cells the right width to display the numbers in all the cells.   <br><br>When the column is too narrow, &quot;####&quot; is displayed as you would expect.  But when I increase the column width to correctly display that cell, other cells in the same column that were displaying correctly now display &quot;# #####&quot;.  <br><br>Increasing the column does not solve the issue.  Highlighting the entire column and doubling clicking on the column separator does not solve the problem.
0
sdt2300
1/10/2010 11:22:30 PM
mac.office.excel 1146 articles. 0 followers. Follow

1 Replies
1049 Views

Similar Articles

[PageSpeed] 9

Highlight all the cells that are affected. Then go to Format > Columns > 
Autofit selection.

will automatically increase colmn width just large enough to accommodate 
the information.

Make sure you don't use to large a Font size, no larger than 9 or 10 pt 
if you can help
and I'd recommend using .5" margins Top and bottom and sides.  Unless 
you want header and footer in that case 1" to and bottom. a good Font to 
use when you want a lot of information  on a page is verdana. Its not so 
pretty but it is readable at low point sizes. My personal preference is 
ITC Benguiat but you need to use it at no smaller than 10 Pt.

sdt2300@officeformac.com wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
> Intel I have a spreadsheet that I created in Excel 2007 (windows) and am
> using in Excel 2008 Mac. I cannot get the cells the right width to
> display the numbers in all the cells.
>
> When the column is too narrow, "####" is displayed as you would expect.
> But when I increase the column width to correctly display that cell,
> other cells in the same column that were displaying correctly now
> display "# #####".
>
> Increasing the column does not solve the issue. Highlighting the entire
> column and doubling clicking on the column separator does not solve the
> problem.

-- 
Phillip M. Jones, C.E.T.    "If it's Fixed, Don't Break it"
http://www.phillipmjones.net           http://www.vpea.org
mailto:pjones1@kimbanet.com
0
Phillip
1/11/2010 1:20:22 AM
Reply:

Similar Artilces:

Format single words in cells
Is it possible to use conditional formatting on individual words inside text cells,rather than on the whole cells? I have a column filled with quotations where I need a keyword to be highlighted in each cell, not the whole cell... Search & replace too seems to be operating on the formatting of whole cells rather than single keywords. Thanks, Gabriele No, it is not possible to get conditional formatting to highlight a single word (of many) in a cell. You would need a macro to do that. Hope this helps. Pete On Nov 17, 2:01=A0pm, Gabriele <Gabri...@discussions.micros...

duplicate SMTP email issue with Exch 5.5 sp4
I am "reposting" this to try and get more feedback. - We have a exch5.5 sp4 environ with multiple servers (1 mail domain). We have noticed that if you connect directly to port 25 and send a single email to both a DL (with User A inside) and User A, User A receives 2 copies (exact duplicate) of the message. This only occurs via straight SMTP. Webmail (yahoo, excite) and Outlook do not cause this issue Has anyone else encountered this issue? What was done to resolve it? While there seems to be significant suspicion of sp4 as the root cause, is anyone running exch 5.5 sp4 or high...

Combining Text in Multiple Cells into One
I am trying to combine text that is in 4 different cells into one cell. For Example: D1 E1 F1 G1 FIRST FLOOR PAVING PLAN DRAWING When combining these cells into one, you would get: H1 FIRST FLOOR PAVING PLAN DRAWING Is there a simple way to do this? Would it be a formula in H1? If so, what formula? Thanks for your help. Brianna Brianna, how about, =D1&" "&E1&" "&F1&" "&G1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit ...

Arrow keys move work sheet and not from cell to cell???
I apparently have inadvertantly checked something so that when I use my arrow keys I do not move to the next cell. Rather the work sheet itself moves. I would deeply appreciate any help here. Thank you in advance for any direction Jerry Touch Scroll Lock -- Gary''s Student - gsnu200847 "JERRY" wrote: > I apparently have inadvertantly checked something so that when I use my > arrow keys I do not move to the next cell. Rather the work sheet itself > moves. I would deeply appreciate any help here. Thank you in advance for any > direction > Jerry >...

Referrence a total in a cell on another worksheet
I have created a workbook to track all my bank deposits, automatic deposits, and credit card receipts. Each worksheet has a cell that contains the total receipts from the deposit entry date. Can I referrence this cell on another worksheet that will total all worksheet totals to date? In other words, I would have a running deposit (income) total for the year on one worksheet. Modify to suit for your first and last ws. =sum(sheet1:sheet10!a2) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "AndreaV" <AndreaV@discussions.microsoft.com> wro...

Data for Chart with Blank Formula Cells
I am trying to chart a worksheet that contains many formulas. When th result of the formula is zero, the cell is instructed to leave the cel blank (which is important to the information being tracked). However when I chart the data, it charts a ZERO for the cell. I tried the interpolate feature, but because the cell has a formula i it, it is not being read as "blank", even though the value is blank. Help! If week one is 2, week three is "blank" (remember, cell actuall has a formula that is returning the blank), and week four is 6, I do get my chart to interpolate from...

Access a cell's Formula, rather than Value
Hello all: I would like to modify this formula so that I use the formula of the cell specified by x, rather than the value stored in the cell. =CHOOSE(x, Sheet1!A1, Sheet2!A1) Thanks, John Not possible, you would need VBA for this. I can't see how by using CHOOSE you would be able to do this even if it was possible to get the formula to replace x since x should be an index number either 1 or 2 (in this case) if you have 2 values? Or have I totally misunderstood? -- Regards, Peo Sjoblom "John Broderick" <none@none.com> wrote in message news:e1RJAHYmHHA.455...

How do I enter cell data in a footer
I'd like to enter a sum total from a cell into a footer on a chart to show how many reponses there were to a feedback questionaire, that is assuming this is possible of course. Hi, You can add a linked textbox to the chart. With the chart active use the formula bar to type in the cells address, including sheet name, so for example the sum total is in cell A12 on sheet1 the formula refrence would be, =Sheet1!A12 when you press Enter the textbox will be added to the chart. Position and format as required. Cheers Andy Carlshep wrote: > I'd like to enter a sum total from a ce...

Data validation based on another cell
Im not quite sure what to put in the title, but heres my problem: I want prevent people from inputing into a cell if other cells have been filled in. A1 has no value B1 has no value C1 has X D1 then cannot have a value because A1:C1 has an X in one of the other three cells :: but if you make C1 have no value then D1 would be able to input an X into that cell, however then the other cells you would not be able to. Im assuming you would use data validation, things ive tried is custom data validation with formulas such as COUNTA(A1:C1)>2, also tried IFTEXT(A1... i tried a few forumlas which...

How do I break up a long text cell into shorter ones withoug spli.
I have a txt cell with between 1 and 200 characters in lenght. I'm trying to break it up into 1 to 6 seperate cells, each with up to 40 characters in it without splitting up any words. So if the 40th character splits a word, I want to split it at the previous space. Then I want to go from that character forward for the next cell, and so on. thanks kevin hi, date>text to columns. use fixed width. set the break where you want it by clicking on the number like just above where you want the break. >-----Original Message----- >I have a txt cell with between 1 and 200 characte...

Spread content of 1 cell over many cells
I just performed the "Text to Columns" function in Excel and it didn't do exactly what I was hoping for. I have a spreadsheet with 1300 addresses in the following format: Street Address City, State Zip I want to change it so that Street Address is a separate column and City, State Zip is a separate column (ie: for a mail merge) I tried using "Text to Columns" and it moved the top line (street address) to a new column, but left the adjacent column in the same format (as above). It's almost like it copied the top line and pasted it in a new column. I want it to act...

Hyperlink Text in Cell
I thought this would be pretty straight forward but I guess I was wrong. I want to create a hyperlink to a web site within a cell. But, I have a large amount of text in the cell and I don't want the whole cell hyperlinked - just the one word. Can this be done? Not directly. I've faked it by formatting the word(s) as a hyperlink and placing a borderless transparent textbox with the hyperlink over the words (set to move and size with cells). In article <2A99C38C-1F27-4FE9-B600-DDAFDA4FF5E3@microsoft.com>, "Jason" <Jason@discussions.microsoft.com> wrote...

How can I enter carriage returns into text within a cell in excel
I am trying to use excel to create a table full of text. I would like to be able to format the text within the cell (e.g. entering carriage returns to put some text on a separate line). I can't seem to make this work. Any suggestions? You need to use Alt-Enter to add line breaks within a cell. Lizzy wrote: > I am trying to use excel to create a table full of text. I would like to be > able to format the text within the cell (e.g. entering carriage returns to > put some text on a separate line). I can't seem to make this work. Any > suggestions? Press Alt+Enter withi...

Displaying document settings
Is there any way to display the various document settings in the body of the document so that they print? I'm referring to paper size, orientation, margins, etc. On Sun, 07 Feb 2010 17:33:54 -0800, Sesquipedalian Sam <sesquipod@nowhere.noway> wrote: >Is there any way to display the various document settings in the body >of the document so that they print? > >I'm referring to paper size, orientation, margins, etc. There's nothing built in for that (you can set an option to print document properties, but that's the information in the File > ...

How to check if the values in a range of cells are greater than 0
Basically I want to check like IF(B3:B5 > 0,B1), if any of the values in B3 to B5 cells are greater than 0 then I take the value from the cell B1. How to do it in a simple way. If I use directly the above mentioned formula, it gives me a #VALUE error Thanks Try this: =3DIF(COUNTIF(B3:B5,">0")>0,B1,something_else) where you decide what you want the something_else to be (eg 0 or ""). Hope this helps. Pete On Mar 19, 10:19=A0am, DP <D...@discussions.microsoft.com> wrote: > Basically I want to check like IF(B3:B5 > 0,B1), if any...

cell color versus gridlines
The default white cell color causes my eyes to strain after a while. In Office 95 and 97 I somehow made all the cells a very light gray by default and had the gridlines in black by default. For the life of me, I can't seem to do this in Office 2003. Any tips? Jean Prepare an empty WB and pre-format it to your convenience. Save it as a TEMPLATE under the name: BOOK.XLT in: C:\Program Files\Microsoft Office\OFFICE11\XLSTART. * Close and reopen "Excel". Micky "Jean" wrote: > The default white cell color causes my eyes to strain after a whil...

Must display as: send on behalf of XXXXXXXX
Hi I hav exchange 2003 and xp pro clients. The PA has the right to send on behalf of the GM but in the From: field is showing that the mail comes directly from her which they don't want. How can i change this so that it display : On behalf of the GM(the name of the name) thanks On Thu, 18 May 2006 22:56:01 -0700, Craig from Huguenot <CraigfromHuguenot@discussions.microsoft.com> wrote: >Hi > >I hav exchange 2003 and xp pro clients. The PA has the right to send on >behalf of the GM but in the From: field is showing that the mail comes >directly from her which th...

increase number of days displayed
2007 Beta Is it possible to increase the number of days displayed in Outlook Today as in this article. http://www.outlook-tips.net/howto/oltoday.htm Barry No... but you can always try using a higher #. (AFAIK, they did not raise the limit, but I haven't tried it either.) -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips: http://www.outlook-tips.net/ Outlo...

Issue with Rules in Outlook
Querry; Have been trying for a while to resolve the issue of a email rule only running at the time of creation and never works next time on messages from same sender to move mesages to correct folder. Setup: 1. Wizard used 2. Trigger is sender ex. Columbia House - DVD 3. Action - move to products folder result - works when created but not on the next set of messages downloaded. Assistance would be greatly appreciated. -- Biggar What type of email account do you have? Do you have any other rules and do they work correctly? -- Diane Poremsky [MVP - Outlook...

Excel 97 Comment Display
Is there a way to cause a comment associated with the active cell only, to be visible, regardless of whether the mouse pointer is "hovering" over the cell? As the user "tabs" or "arrows" across the worksheet, I would like the comment for the active cell to pop up, while comments associated with the inactive cells remain invisible. One way: Put this in the worksheet code module (right-click the worksheet tab, choose View code and paste the sub into the window that opens): Private Sub Worksheet_SelectionChange( _ ByVal Target As Excel.Ran...

Username Display Problem
We are using Outlook 2003. When I rename a user in active due to marriage, etc. I change the user's active directory account name to reflect the change. I do see the recipent policy take affect and it changes their email address. However when in Outlook 2003 and I start typing their name it comes up with part of the old name. Example: 'Prince Albert' displays when typing in the To: field as 'Prince Albert <PAlbert>' If I rename 'Prince Albert' to 'Prince Bumble' the display when typing in the To: field displays as 'Prince Bumble <PAlbert>...

Fill-colour a cell dependent on formula
Formula in C1 - =IF(A1<B1,"Green",IF(AQ<B1/0.95,"Red","Amber")) How can I fill-colour the cell to change to the colour (Green, Amber or Red) rather than show the word of the colour. Many thanks in advance. Take a look at Conditional Formatting in XL Help. In article <68E046F9-A489-4C1A-BCC1-49692478DAE1@microsoft.com>, Kim Duffy <KimDuffy@discussions.microsoft.com> wrote: > How can I fill-colour the cell to change to the colour (Green, Amber or Red) > rather than show the word of the colour. ...

Money login issues
Any news on the broken Microsoft Money login and passport issues? ...

Moving Outlook data between hosted Exchange provider issues
Hi, I have been using hosted Exchange for the last couple of years provided by a third party accessed via RPC over HTTPS and due to a new job am moving to another third party Exchange provider. My mailbox is currently around 400Mb and up till now have been using Outlook 2007 which I intend to continue using. I tried to export my mailbox using File > Import/Export > Export to file > Personal Folder File (.pst) and select complete mailbox including sub folders. This creates a .pst archive of about 400Mb containing my mailbox. I then changed the mail account settings to point...

how do you format a row of cells based upon a value in another ce.
how do you format a row or a range of cells based upon a value in a cell not included in the conditional format? Hi select the cells to have the conditional formatting on them choose format / conditional formatting choose formula is type the criteria (ie =$E$1>50) click the format button to apply the formatting. Cheers JulieD "hazenb1" <hazenb1@discussions.microsoft.com> wrote in message news:F8444919-2907-4E44-900F-D1372494CF7F@microsoft.com... > how do you format a row or a range of cells based upon a value in a cell > not > included in the conditional form...