| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
0 on mobile numbers
How do I stop mobile numbers losing 1st 0 digit when I press enter?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
0 on mobile numbers
Format the cell as Text prior to entering the data, or precede
the data with an apostrophe. The apostrophe will not show in the cell but will in the formula bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "shazemmo" wrote in message ... How do I stop mobile numbers losing 1st 0 digit when I press enter? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
| Validating random numbers | Excel Worksheet Functions | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Linear Mode
