number formatting

[hz76p5]

Hi,

I would like to get some expert help

I would like to eliminate any unnecessery 0 from numbers.
e.g.: instead of 0.00347 i want to se 3.47
How can I form the cell to get this form? ( without any multiplying

 

[RagDyer]

<"( without any multiplying)">

How about dividing ? =A1/0.001 <bg>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi,

I would like to get some expert help

I would like to eliminate any unnecessery 0 from numbers.
e.g.: instead of 0.00347 i want to se 3.47
How can I form the cell to get this form? ( without any multiplying)

 

[Freemini]

if you really want to do it without multiplying or dividing try this,
with your entered value in A1 = 0.00347 enter the following formula
into B1

=VALUE(LEFT((TEXT(A1,"##.##E+00")),(FIND("E",(TEXT(A1,"##.##E+00")))-1)))

this will give B1=3.47

Hope this is what you wanted

Mike