When I type a mobile number in Excel it wont include the first 0
 

How do I get the 0 of the start of mobile numbers to stay in the excel cells

When I type a mobile number in Excel it wont include the first 0
 

1st way: format cell as text before inputting into it.
2nd way: type an ' (apostrophe) before the number.

Regards,
Stefi


€žA Annett€� ezt Ã*rta:

How do I get the 0 of the start of mobile numbers to stay in the excel cells

When I type a mobile number in Excel it wont include the first 0
 

Precede the number with a single quote (apostrophe).
--
Gary''s Student


"A Annett" wrote:

How do I get the 0 of the start of mobile numbers to stay in the excel cells