Gene,

To show the number from cell A1 in another cell with as conditional number of decimal places, use a
formula like

=TEXT(A1,"0." & REPT("0",some conditional formula that returns a number)

like:

=TEXT(A1,"0."&REPT("0",IF(A1100,2,3)))

But then it isn't a number - some functions will treat it as a number ( using +, for example) while
others (SUM()) will not...

HTH,
Bernie
MS Excel MVP


"Gene Herron" <Gene wrote in message
...
I want to set the number of decimal places for a cell based on a condition in
another cell. You cna't do that in conditional formatting. Is there another
way?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions