View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default space needed between number& right side of cell

Maybe you could use a custom format of:

#,##0.00" "

(or some variation)

Jack B wrote:

Re Excel 97 ---

I would like to format a bunch of cells so that when I enter numbers they
will not be flush against the right side of the cell -- I want to have a
space between the numbers and the right side of the cells without having to
hit the spacebar after each number. How do you do that?

Jack


--

Dave Peterson