How can I keep zeros in the beginning of a mobile number @
 

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

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
©¿©¬

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

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?

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

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!