Ensure column width is adequate across systems

R

RBeau

I have a finanical tool based on excel. When I view the data I do not see any
## cells, but when other people view the same data in the tool they do. I
know I can increase column width or reduce the size of the font, but is there
something in excel that displays the same data differently on different
systems? Is there a way to ensure that what I am seeing is what they will see?

Thanks in advance for any suggestions.
 
D

Dave Peterson

I think that the only way to really insure this is to do the stuff you
suggested--increase the columnwidth or reduce the font size.

Actually, there's another option.
Format|Cells|Alignment tab|check Shrink to Fit
(it automatically adjusts font size)

But (my opinion only) there are too many variables that you'd have to
know--display settings and printer drivers, and windows default date
formats--and even zoom level for that window.

I use a short date of mm/dd/yyyy (I like four digit years and leading 0's for
days and months). Lots of people use mm/dd/yy or even m/d/y.

I often have to widen columns with dates because January 1, 2006 looks fine on
their pc (1/1/06), but is too wide for my pc (01/01/2006) and I get the dreaded
####'s.

(And it's one of those really easy things to forget to do after you've autofit
the columns. But heck, that's what release x+1 is for!)
 
Top