| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| I type 1050 -Excel changes it to 1005 | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
| Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions | |||
Linear Mode
