Hi Epinn

Identity theft is a big thing

Definitely not into identity, theft - just nice to know who one is
"talking to" - but it remains your choice of course.


--
Regards

Roger Govier


"Epinn" wrote in message
...
Roger,

It's hard for me to explain without the screen. I heard you and I
followed exactly what you said previously. Maybe if you try to actually
do what I did, say keying into A1, you'll know what I mean?? Data
didn't get truncated while typing but after formatting. If I start in
A1 (i.e. following your previous instructions) the first part (monthly
fore) of the title gets truncated *after* the format. It has nothing to
do with column width. I'll digest your new post some more later. I key
in before I format, right?

Thank you for filling in the blank. I have been wondering what the last
"n" of Epinn should stand for. You just gave me the answer. Yes, "n"
for number. That's very good and it makes sense. As I said, "e" stands
for electronic. "Pinn" is actually the first part of a word (talking
about truncation) which I use as my cyber last name. Confused? But,
"electronic PIN number" is really good. So, I have "made a name" for
myself on this board.

The other day, Bob asked me about my nationality, now you want to know
my gender? My dear friendsss, someone who frequents the MS boards has
been watching me closely for quite a while and finally he revealed
himself to me. He may even be reading this post while you do. I should
really keep a low profile and refrain from posting. I hope you do
understand. If anyone secretly finds out anything about me, I urge you
to keep it to yourself and don't advertise it on the board. If you have
figured out the long form of Pinn, please don't say it. It's okay to
repeat what I have told you via my posts though. I should do a better
job not to reveal too much of myself. Identity theft is a big thing.
Someone's house was sold as a result of title fraud, identity theft etc.
and the genuine owner still couldn't get it back after seven months and
thousands and thousands of $$$$.

Sorry for the distraction and I wish everyone safety on the 10th. of
September.

Electronic Pin Number

"Roger Govier" wrote in message
...
Hi Epinn

Mark the range of cells A1:C1, then
FormatCellsAlignmentSelect the Horizontal dropdownCenter across
selection
There is nothing to stop you from starting to type in A1.
If the data is truncated, then you need to widen the columns.
You do not get gridlines in between.

If you do not have any data in B1 or C1, then just typing the whole of
the text in A1, will give the appearance of a single cell without
gridlines

Choosing Merge, also truncates the data, unless you widen the column(s)

Incidentally, I noted from earlier postings Epinn is an acronym of
(Electronic (pin) (n)umber but you do not say whether you are male or
female?

--
Regards

Roger Govier


"Epinn" wrote in message
...
Thanks for your response, Roger. I am aware of this feature but I can't
get it to produce the same effect as merging cells will. Am I missing
something?

Let's say I have Jan Feb Mar ........ starting from A2 and going across.
Above the months and in row 1, I want to include a heading say "Monthly
forecast for the year of 2007."

With merge cell feature, I can start typing "Monthly ......" in A1, and
when I am finished keying, I can select my range and press the "merge
and centre" button. It will be centered in one big cell.

With the format feature, I can't start typing in A1. If I do, then part
of the heading will be truncated after I do format etc. and it won't
centre although I tick the box. If I start typing in C1, I can see the
entire heading but it won't centre either. Besides, the gridlines are
there.

I have used format|alignment etc. for a single cell and it is fine. If
I use it for multiple cells I usually click the "merge cells" box and it
is fine too. But since we are on the subject of NOT merging, so I don't
click the box and things just don't look right.

Wonder what's going on here.

Epinn

"Roger Govier" wrote in message
...
Hi Epinn

Mark a range of cells
FormatCellsAlignmentCentre across Selection

--
Regards

Roger Govier


"Epinn" wrote in message
...
Bob,

Then, how do I spread a column heading across a few columns? Just don't
make it one big cell?

Epinn

"Bob Phillips" wrote in message
...
Epinn,

Don't merge cells, it is more trouble than it is worth.

--
HTH

Bob Phillips