View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬[_4_] Martin ©¿©¬[_4_] is offline
external usenet poster
 
Posts: 15
Default 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?