Sounds like you'll need a helper column, or you'll need a worksheet change
event. Which are you open to? Extra column or macro?
*******************
~Anne Troy

www.OfficeArticles.com


"Branden" wrote in message
...
On my spread sheet I have a column with different equipment numbers. If
the
number starts with 25 it needs to have 4 decimal places (25.4444) if it
starts with a 26 it needs to have 3 decimal places (26.333). Not sure how
to
do this we tried conditional formatting and it does not give decimal as
option. We tried to format as general but it would drop the zero off the
end.
Example 26.330 would be 26.33.