On Jan 19, 2:13*am, Bernd P wrote:
IF using a formula, why not
=--TEXT(A1,"##0E+0")
formatted General?

Does that work for you? If so, what version of Excel are you using?
Using Office Excel 2003, that does not meet the OP's specifications,
if I understand you correctly. I put that formula into B1, formatted
General. In A1, I try the following values:

A1: 4567000
OP wants: 4570000
My formula: 4570000
Your formula: 5000000

A1: 2.4678
OP wants: 2.47
My formula: 2.47
Your formula: 2

A1: 12.35
My formula: 12.4
Your formula: 12

A1: 0.001235
My formula: 0.00124
Your formula: 0.001

Note: Your formula does work the OP's examples of 567.9 and 0.235.