On Fri, 14 Dec 2007 20:03:34 +0000, Brian Barker wrote:
>
> Use:
> =RIGHT(" "&A1;7)
> This concatenates a sufficient number of spaces to the front of the
> string and then selects the seven rightmost characters from the
> resulting string.
>
Hmmm... Ok, that'll do. I was hoping for formatting only, not functions.
But that's fine.
> (I'm assuming that your strings of nines are text
strings, not numbers,
> of course.)
>
No, some are numbers. But I thing that using the & operator automatically
converts a number to a string. I'll test, anyway.
Thanks!
L
--
Prenez la parole en public en étant Speak to an audience while being
moins nerveux et plus convaincant! less nervous and more convincing!
Abonnez-vous au bulletin gratuit! Sign up for the free newsletter!
http://www.duperval.com (514) 902-0186
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
