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

  • Thread starter Thread starter StargateFanFromWork
  • Start date 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! :oD
 
Have you tried Format>Cells>Alignment>Horizontal>Right Indent and set for 2?


Gord Dibben MS Excel MVP
 
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
 
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! :oD
Click to expand...

It seems to work fine here.

What are your text alignment settings? All of mine were DEselected.
--ron
 
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. :oD
 
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. :oD
 
Back
Top