On Thu, 27 Apr 2006 08:40:02 -0700, nastech
wrote:

thankyou again, is there any work around? maybe not critical then, but should
I post as a script request question, or do you think that might be wasted
time? (resources etc.)

"Ron Rosenfeld" wrote:

On Wed, 26 Apr 2006 20:18:01 -0700, nastech
wrote:

060426-5 Need Custom format, not a formula
(Not looking for formula's).

Just need "Custom Format" for how column of e.g.: 1.511B will look like: 2B
That which you get by: Right-Click cell, Format Cells.., Number tab,
Custom:
then what do you type in place of #,##0?
(question mark included in this example)
may not be wording this right?

column has e.g.: 1.511M 1.511B

Custom formats only work for numeric values. Since 1.511B is not a numeric
value, but rather a text value, you will not be able to do what you want with a
custom format.


--ron


If you can use a formula, it would be simple to translate your 1.511B; 1.511M;
etc.

Without knowing the range of values you might be using, it's a bit hard to come
up with a general formula.

Also, depending on whether you want the result to be a "text string" or a "real
number", the method would be different.

So if you can define your requirements more completely, a solution will be
forthcoming.
--ron