Hi, thanks for the patience. I guesse I've had a couple of precepts,
but
wasn't sure what real answer was..
- as presented, have these that work:
=TEXT(LEFT(BZ9,LEN(BZ9)-1),"#,##0")&RIGHT(BZ9,1)
=IF(OR(CE9=0,BZ9={0,"n/a"}),"",
(LEFT(BZ9,LEN(BZ9)-1)*IF(RIGHT(BZ9,1)="b",10^9,1)/CE9*$BV$4))
- also figured would be a work around for just about anything/ can't
beleive
this isn't possible for so simple a thing, would be?: #? as a
format
- don't think its a math thing? just lack of programming
- told by more than one, can program a computer to do anything.. emc
mass
data storage programmers... thanks again
Ron Rosenfeld said:
hi... have equations to manipulate the data at will.
- each number is 99% of time followed by B or M, occasionally will have
straight up number less than 1M, e.g.: 832555
- each number is in its own cell.
How do you want a value like 83255 to be displayed in the cell?
What is need is Custom Format for "View" of those numbers, as previous
couple of posts, maybe something like:
WHAT NEED:
gross idea: (probably won't work, general means formatting?) FIX NEXT LINE.
[#.#B]#,,,"B";[#.#M]#,,"M";General
As has been written a number of times by various contributors, formatting will
only affect numeric values. There is no way to have a cell contain a value of
1.5B and display 2B. You can do that in an adjacent cell with a formula, or
you can use a macro to actually change the value in the same cell, but then you
will lose your original value.
So you are going to have to decide what you want now that you know what is
possible.
Once you answer my question as to how you want 832555 to be displayed, then I
can modify the formula I gave you earlier to take that into account.
--ron
