Custom Formatting
 

Hi, am looking for way to custom format cell to read 1.511B or 1.511M
as: 1B 1M (both B for billion & M.. present in column, thanks)

may need to use worker column to get rid of unwanted digits? but
separate work column might not work for me, but would be:
=TEXT(LEFT(BZ9,LEN(BZ9)-1),"#,##0")&RIGHT(BZ9,1)

Just looking for custom formatting such as: #,##0? ??

Is this an area not possible for custom formatting in Excel?

Custom Formatting
 

Try
=IF(A1=1000000000,TEXT(A1/1000000000,"#.000")&"
B",TEXT(A1/1000000,"#.000")&" M")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"nastech" wrote in message
...
Hi, am looking for way to custom format cell to read 1.511B or 1.511M
as: 1B 1M (both B for billion & M.. present in column, thanks)

may need to use worker column to get rid of unwanted digits? but
separate work column might not work for me, but would be:
=TEXT(LEFT(BZ9,LEN(BZ9)-1),"#,##0")&RIGHT(BZ9,1)

Just looking for custom formatting such as: #,##0? ??

Is this an area not possible for custom formatting in Excel?

Custom Formatting
 

Hi, thanks for the response, (looks like another way to do it), but the one
used below does exactly that, and works for both B/M values. Question
actually is for "CUSTOM Formatting" (cannot use worker column for reasons
of local of copy-paste situation).

The Following is Probably Incorrect, but need the answer for RIGHT-CLICK ON
CELL, FORMAT CELLS, CUSTOM, THEN????? something like:

#,##0? maybe with a wild-card "?" for the last letter in Number/ Text
combo.

"Bernard Liengme" wrote:

Try
=IF(A1=1000000000,TEXT(A1/1000000000,"#.000")&"
B",TEXT(A1/1000000,"#.000")&" M")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"nastech" wrote in message
...
Hi, am looking for way to custom format cell to read 1.511B or 1.511M
as: 1B 1M (both B for billion & M.. present in column, thanks)

may need to use worker column to get rid of unwanted digits? but
separate work column might not work for me, but would be:
=TEXT(LEFT(BZ9,LEN(BZ9)-1),"#,##0")&RIGHT(BZ9,1)

Just looking for custom formatting such as: #,##0? ??

Is this an area not possible for custom formatting in Excel?