Perhaps a variation of:

=IF(A110000,TEXT(TRUNC(A1/1000,2),"0.00"),TEXT(A1,"0"))

will help you.


nastech Wrote:
Hi, I am trying to find a way to vary the format for a column of
numbers,
that depend on the size of the input.
Would like to change from zero decimal places, to 2 decimal places if
1000,
(am using alternate input if 1000: i.e. Input/1000, then NEED 2
decimal
places).

Is there a way to modify the number of decimal places viewed, inside
an
equation. I am using:

=IF(AG9=0,"",IF(AT111000,TRUNC($AT$7/AG9,2),($AT$5/AG9)))

will / need to see number: e.g. 1085, to 1.08; (no rounding up)

If function exists, is it possible to modify decimal places from a
single/
absolute cell. thanks in advance.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=481765