Hi!
It makes relevance for me in case I have a single decimal of a figure less
than 10 (ex: 9.2, 2.1), but no decimal if the value is 10 or above
Is there a way to do this customization through format
Any takers?
--
Dr. Sachin Wagh
MBBS, DHA, DPH
[lt;10]0.0;0
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Dr. Sachin Waghquot; gt; wrote in message
...
gt; Hi!
gt;
gt; It makes relevance for me in case I have a single decimal of a figure less
gt; than 10 (ex: 9.2, 2.1), but no decimal if the value is 10 or above
gt;
gt; Is there a way to do this customization through format
gt;
gt; Any takers?
gt; --
gt; Dr. Sachin Wagh
gt; MBBS, DHA, DPH
Thanx a ton Bob; life's more comfortable now!
--
Dr. Sachin Wagh
MBBS, DHA, DPHquot;Bob Phillipsquot; wrote:
gt; [lt;10]0.0;0
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Dr. Sachin Waghquot; gt; wrote in message
gt; ...
gt; gt; Hi!
gt; gt;
gt; gt; It makes relevance for me in case I have a single decimal of a figure less
gt; gt; than 10 (ex: 9.2, 2.1), but no decimal if the value is 10 or above
gt; gt;
gt; gt; Is there a way to do this customization through format
gt; gt;
gt; gt; Any takers?
gt; gt; --
gt; gt; Dr. Sachin Wagh
gt; gt; MBBS, DHA, DPH
gt;
gt;
gt;
- Aug 07 Thu 2008 20:45
Custome Number format based on Value
close
全站熱搜
留言列表
發表留言
留言列表

