Re: Formatting Cell Using Formulae....advise please....

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Bob,
I do understand what the Proper function does now, but it does not do for me
what I thought it would to do.

Initial Question Reworded
What is the most commonly used way to format text in a spread*** for best
readability and appearance?

How would I achieve this?

Thanks
Dermot

"Dermot" wrote:

> Hi Bob,
> Quote
> The second would require VBA.
>
> I have looked for some code to do this bob.....
> could you suggest some, thanks
> Dermot
>
> "Bob Phillips" wrote:
>
> > On the first point, you would enter the PROPER formula in an adjacent cell,
> > then copy down for all rows.
> >
> > The second would require VBA.
> >
> >
> > Formatting does not change the content, just its appearance, so it will not
> > make ordinary text, proper case text, nor change Y to Yes.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Dermot" <Dermot@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:76F1CCA2-26D3-4C05-8052-53F4D7C79E04@xxxxxxxxxxxxxxxx
> > > I am trynig to understand how to format a column to use the "Proper"
> > argument.
> > > The help example appears to be for one cell only I whould like say all
> > first
> > > names and second names to start with capitals. I can't seem to set this
> > up. I
> > > end up with either the formula showing in one cell or a circular error. I
> > > don't think I have to format each cell individually in a column?
> > >
> > > I would also like to know how to format a column so the when I press the
> > > letter Y or N it enters Yes or No as typed here?
> > >
> > > Any other suggestions how I can get to grips with the formatting ffeatures
> > > would be appreciated.
> >
> >
> >
.

Quantcast