View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default why do some cells show up as XXXX's on a shared drive

I think you mean ######

The columns are too narrow so widen them.

The reason it occurs on some setups and not others is probably due to
resolution and/or printer drivers being different.

You have to get everyone standardized on both accounts.


Gord Dibben MS Excel MVP


On Wed, 10 Sep 2008 18:02:01 -0700, Thomas Bren <Thomas
wrote:

I am building spreadsheets to be viewed on another computer on our shared
drive. However, sometimes cells with the date in them show up as XXXXXX's.
Similarly, some cell with formulas to do sums show up as XXXXX's also. Is
there a difference in the settings on the two computers? If so, how do I fix
this?