Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I keep zeros in the beginning of a mobile number @
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I keep zeros in the beginning of a mobile number @
Hi Martin,
Am Mon, 11 Nov 2013 19:08:23 +0000 schrieb Martin ©¿©¬: format the cells as text. Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I keep zeros in the beginning of a mobile number @
On Mon, 11 Nov 2013 20:13:47 +0100, Claus Busch
wrote: Hi Martin, Am Mon, 11 Nov 2013 19:08:23 +0000 schrieb Martin ©¿©¬: format the cells as text. Thank you Claus B. However, 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? -- Martin ©¿©¬ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I keep zeros in the beginning of a mobile number @
Hi Martin,
Am Mon, 11 Nov 2013 19:26:07 +0000 schrieb Martin ©¿©¬: However, 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? open the error smarttag and click "ignore" Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I keep zeros in the beginning of a mobile number @
On Mon, 11 Nov 2013 20:34:22 +0100, Claus Busch
wrote: Hi Martin, Am Mon, 11 Nov 2013 19:26:07 +0000 schrieb Martin ©¿©¬: However, 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? open the error smarttag and click "ignore" Regards Claus B. So everytime I input a number I have to do that? Is ther a better way? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I keep zeros in the beginning of a mobile number @
Hi Martin,
Am Tue, 12 Nov 2013 15:13:38 +0000 schrieb Martin ©¿©¬: So everytime I input a number I have to do that? Is ther a better way? what do you mean? To ignore the error? You can go to Excel options = Formulas and deactivate this error. If your cells are adjacent all same errors will be ignored if you once do it. If you mean the formatting you can format the whole column to text. Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I keep zeros in the beginning of a mobile number @
"Martin ©¿©¬" wrote:
On Mon, 11 Nov 2013 20:34:22 +0100, Claus Busch wrote: Am Mon, 11 Nov 2013 19:26:07 +0000 schrieb Martin: However, 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? open the error smarttag and click "ignore" [....] So everytime I input a number I have to do that? Is ther a better way? Yes, disable "background error checking". How you do that depends on the version of Excel, which you did not mention. For Excel 2003, click on Tools, Options, Error Checking, and deselect "Enable background error checking". For Excel 2010, click on File, Options, Formula, and deselect "Enable background error checking". What you need to realize is: usually these are not real errors, despite Excel's effort to mislead you. Instead, they are warnings that Excel has determined something in those cells is different from some adjacent cells. Different; not necessarily an error. Excel just wants to draw your attention to the difference, on the off-chance it is indeed a mistake. But 99 times out of 100, there is no mistake at all. You have simply chosen to do something different. Klunk! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing zeros at the beginning of a number | Excel Discussion (Misc queries) | |||
How can I keep zeros in the beginning of a number in excel | Excel Discussion (Misc queries) | |||
How do I display zeros in excel if they are the beginning characte | Excel Discussion (Misc queries) | |||
How do I get the zeros to show up in the beginning of a number? | Excel Discussion (Misc queries) | |||
csv file drops zeros at beginning of a set of Numbers | Excel Discussion (Misc queries) |