Getting space between text and right border. " " not working.

  • Thread starter StargateFanFromWork
  • Start date
S

StargateFanFromWork

I have a =NOW() cell formatted as:

yyyy.mm.dd.ddd., hh"h"mm

but even when I make it:

yyyy.mm.dd.ddd., hh"h"mm" "

I don't get any more space between the end of the time and the right-hand
border and it's printing too close to the edge.

What is the fix for this one, pls? Thank you! :eek:D
 
G

Gord Dibben

Have you tried Format>Cells>Alignment>Horizontal>Right Indent and set for 2?


Gord Dibben MS Excel MVP
 
P

Pete_UK

Instead of a normal <space> at the end of your format string, you
might like to make it the non-breaking space character - hold down the
Alt key and type 0160 on the numeric keypad. You might like to do it
twice or three times, depending on how much of a gap you want.

Alternatively, why not apply a centre alignment and make the column a
bit wider?

Hope this helps.

Pete
 
R

Ron Rosenfeld

I have a =NOW() cell formatted as:

yyyy.mm.dd.ddd., hh"h"mm

but even when I make it:

yyyy.mm.dd.ddd., hh"h"mm" "

I don't get any more space between the end of the time and the right-hand
border and it's printing too close to the edge.

What is the fix for this one, pls? Thank you! :eek:D
Click to expand...

It seems to work fine here.

What are your text alignment settings? All of mine were DEselected.
--ron
 
S

StargateFan

Try turning wraptext off.
Click to expand...

Ah, I think that's it. That's what was stumping me as I've used this
trick before but it didn't work here.

I'll test on the document in question tomorrow at the office, but I'm
hopeful that that is the solution there, too.
It seemed to make a difference in xl2003.
Click to expand...

Oh, boy, I _keep_ forgetting to mention the version I work with. Stil
using XL2K, here and at the office <g>.

Thanks. :eek:D
 
S

StargateFan

Have you tried Format>Cells>Alignment>Horizontal>Right Indent and set for 2?
Click to expand...

Kewl, you must not be talking of XL2K? I keep forgetting to mention
that I'm using a very old version. But I'm betting that's a new thing
in Excel. I only have left indent option.

Thanks. :eek:D
 
Top