XL XP dissapearing (hidden) numeric values, cell width

  • Thread starter Thread starter Keith R
  • Start date Start date
K

Keith R

This is a newbie question, but...

I was just upgraded to Windows and Office XP, and am working on a workbook
to help someone out at work.

I have several very narrow columns (for formatting reasons that affect other
rows)

My target cell is right justified, so that anything that shows will overlap
to the left (right side of cell is the border of print area)

When I put text in the cell, it overlaps to the left as expected. With
numbers, the numbers don't overlap the cell border, and are therefore not
visible (similar to when you have a number too large for a regular-sized
column, it shows "####"- my column is so narrow I cant even see the ###)

Is there a way to indicate, for certain cells, or an entire workbook, that
numeric values should overlap cell borders if adjoining cells are empty? My
less desirable alternative is to concatenate a (" ") blank space on the
front of every number to show it as a text string and make sure the zeros
show...

Thanks in advance,
Keith
 
Back
Top