How can I keep a zero at the beginning of a mobile number?

[Martin ©¿©¬]

Hi
When typing a mobile number in a cell I put a ' in front & get &
formula error message .
What is the correct way do this?

 

[Ron Rosenfeld]

Hi
When typing a mobile number in a cell I put a ' in front & get &
formula error message .
What is the correct way do this?

I cannot reproduce your problem.
What, exactly, are you typing?
What, exactly, is the nature of the "formula error message"?

 

[Martin ©¿©¬]

I cannot reproduce your problem.
What, exactly, are you typing?
What, exactly, is the nature of the "formula error message"?

When I input a mobile number there is still a little green triangle
in the upper left-hand corner of the cell, saying thet there is an
error in the formula?

 

[Claus Busch]

Hi Martin,

Am Tue, 12 Nov 2013 15:15:13 +0000 schrieb Martin ©¿©¬:

When I input a mobile number there is still a little green triangle
in the upper left-hand corner of the cell, saying thet there is an
error in the formula?

that is not an error in a formula. This is because you have
text-formatted numbers. Deactivate this error in Excel-Options =>
Formulas => Error rules


Regards
Claus B.

 

[Martin ©¿©¬]

Many tn Tue, 12 Nov 2013 16:23:50 +0100, Claus Busch

Hi Martin,

Am Tue, 12 Nov 2013 15:15:13 +0000 schrieb Martin ©¿©¬:


that is not an error in a formula. This is because you have
text-formatted numbers. Deactivate this error in Excel-Options =>
Formulas => Error rules

Many thanks Claus,
Thats got it now