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

  • Thread starter Thread starter Martin ©¿©¬
  • Start date Start date
M

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?
 
I cannot reproduce your problem.
What, exactly, are you typing?
What, exactly, is the nature of the "formula error message"?
Click to expand...

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?
 
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?
Click to expand...

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.
 
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
Click to expand...

Many thanks Claus,
Thats got it now
 
Back
Top