number formatting

H

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
 
R

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)
 
F

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
 
Top