Need Custom format, not a formula
thankyou
"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
|