Welcome to MacForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Accounting Format Zoom issue at 125%

  
   Macintosh computer (Home) -> Excel RSS
Next:  VB Editor - Command key stuck?  
Author Message
TNT

External


Since: Feb 03, 2008
Posts: 1



(Msg. 1) Posted: Sun Feb 03, 2008 3:32 pm
Post subject: Accounting Format Zoom issue at 125%
Archived from groups: microsoft>public>mac>office>excel (more info?)
When zooming in on sheets with cells in accounting format, numbers will appear as ###### ################### regardless of column width. Values appear correctly in the formula bar, but not on the sheet. This occurs at zoom settings of 121 - 125%. Other zoom settings display values correctly. Very odd . . .<br>
<br>
Can't find this issue on any of the blogs thus far.

 >> Stay informed about: Accounting Format Zoom issue at 125% 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 2394



(Msg. 2) Posted: Sun Feb 03, 2008 8:19 pm
Post subject: Re: Accounting Format Zoom issue at 125% [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article , TNT DeleteThis @officeformac.com
wrote:

> When zooming in on sheets with cells in accounting format, numbers will
> appear as ###### ################### regardless of column width. Values
> appear correctly in the formula bar, but not on the sheet. This occurs at
> zoom settings of 121 - 125%. Other zoom settings display values correctly.
> Very odd . . .<br>
> <br>
> Can't find this issue on any of the blogs thus far.

I can't reproduce this - does it happen with all sheets?

Does changing the font affect the problem?

Does anything change if you change formats and reapply Accounting?

 >> Stay informed about: Accounting Format Zoom issue at 125% 
Back to top
Login to vote
TNT

External


Since: Feb 04, 2008
Posts: 1



(Msg. 3) Posted: Mon Feb 04, 2008 12:45 pm
Post subject: Re: Accounting Format Zoom issue at 125% [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Played around a bit and think I figured out the bug. Has to do with opening a sheet originally produced in a MS Excel for Windows. For some reason, the font and/or font size is not coming across. By going into cell formatting I was able to simply specify a font and font size, which eliminated the issue.<br>
<br>
This should probably be reported to MS for a fix, since it's going to be a pain to concern oneself with ongoing compatibility. In the biz world, most sheets will be produced from a PC and not a MAC.<br>
<br>
Any idea where to report this issue so they can work and a patch?
 >> Stay informed about: Accounting Format Zoom issue at 125% 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 2394



(Msg. 4) Posted: Mon Feb 04, 2008 2:07 pm
Post subject: Re: Accounting Format Zoom issue at 125% [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article , TNT <> wrote:

> Any idea where to report this issue so they can work and a patch?

Choose Help/Send Feedback... in XL.
 >> Stay informed about: Accounting Format Zoom issue at 125% 
Back to top
Login to vote
Chip Howland

External


Since: Feb 29, 2008
Posts: 1



(Msg. 5) Posted: Fri Feb 29, 2008 9:00 am
Post subject: Re: Accounting Format Zoom issue at 125% [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I am experiencing the same problem when using the font Helvetica Condensed with the accounting format. My spreadsheet was created with the Mac version of Microsoft Excel 2004.
 >> Stay informed about: Accounting Format Zoom issue at 125% 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Column won't recognize format command - Vlookup issue! - I have two files with the first column being an eight-digit identifier that is formatted as General. However, the vlookup command won't work because one of the files refuses to recognize the General cell formatting no matter how many times I try to chang...

Zoom - When I open a new worksheet the Zoom button in the toolbar is set to 100%. Is there a way to have the Zoom button set to 125% whenever I open a new worksheet?

Remembering Zoom - I have purchased a 19 inch CRT and use 1280x1024 resolution, which is a tad small for my eyes I regularly set the zoom to 110% which makes all fine. I have to do this everytime I open an excel file, can I have Excel remember this setting. Thanks in..

Automatically Zoom Upon Opening - Some time ago, the great folks here helped me with some code to automatically resize worksheets to fit the screen. I retained the code that re-sizes sheets when the user moves from one sheet to another, but I can't find the code that will automatically....

cvs format - I am a new user of Mac and excel. I am having a problem formatting lists to the cvs,coma delimited format. I have received zip files in cvs format. I then copy and paste these files into excel. I then edit the file deleting some information and..
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]