Even more than John suggests, it would help to provide a much more accurate
& thorough description of the situation. That includes the exact version &
update level of Office as well as OS X in addition to the specific nature of
the content, the origin of the workbook, what the cells 'should' be
displaying, what formatting is being used, etc. What you're vaguely
describing is virtually unheard of, so we need to have as much detail info
as possible in order to help determine what might be the cause.
Excel will display the # character if a cell contains a formatted value in a
column not wide enough to display the entire content, but I've never see it
display X characters under any circumstances [although I suppose there could
be a Language influence]. Even so, Zoom percentage doesn't typically trigger
the #s to display because the entire window content is affected
proportionately, not just the content of certain cells - regardless of what
their content is. On rare occasions the disparity between a specific Zoom
value & the system's display capabilities can cause the # to display, but a
slight change to the Zoom setting normally corrects that.
Regards |:>)
Bob Jones
[MVP] Office:Mac