What is the best way to program the custom cell format

  • Thread starter Thread starter Owen Zhang
  • Start date Start date
O

Owen Zhang

I need to have a format of all the cells of selected row to be 8
characters and if the word of the cell is less than 8 characters,
then
padding with space. For example, if I enter "ABC" in one of the cells
of the row, then the format will automatically become "ABC ",
which 5 spaces automatically appended to "ABC".
 
You can use custom format in cell

like

@" "

then the entry is allways FORMATED (as You requested) with 5 spaces after
But You never "see" them 5 spaces without aligning cells to right

Henn
 
Back
Top