Re: [Skate] Excel errors.

Hello

This seems to be so easy! But it is not. Changing this makes some of the 
cells ok buta lot other change from Text sels or number cells to date! 
When this occour the info in the cells is not regognised.

The books and the sheets has been changed to something I don't 
understand and I don't see it.

I have not the knowledge to find out what has happened. I can send to 
the one that want to look at and what has happened and then I can do the 
work if I know what to do.

Regards
Steinar


Den 16.03.2018 10.21, skrev Tim Wolfkamp [email protected] 
[Speed_skating]:
> Hi Steinar,
> 
> Replace the &","& by &"."& (comma setting)
> 
> kind regards
> 
> Tim
> 
>  > Op 15 maart 2018 om 22:57 schreef "Steinar Vissebråten 
> [email protected] [Speed_skating]" <[email protected]>:
>  >
>  > Why does my calculation in excel like this return an error like this:
>  > 
> =IF(Q2="";"";(IF(LEN(Q2)=5;Q2;LEFT(Q2;2)*60+MID(Q2;3;2)&","&RIGHT(Q2;2)))/3)
>  >
>  > Error:
>  >
>  > #VALUE!
>  > The calculation is like this:
>  >
>  > #VALUE!
>  > Furmula >=IF(Q2="";"";TRUNC(X2;3))
>  >
>  > Is there anything I am missing in the setup?
>  >
>  > It all happened after WIN10 update followed with a main PC failure.
>  >
>  > Thank for using your bains.
>  > Steinar
>  >
>  > --
>  >
>  > Steinar Vissebråten, Liavegen 149,
>  > N-3540 Nesbyen,NORWAY
>  >
>  > ------------------------------------
>  >
>  > Posted by: =?UTF-8?Q?Steinar_Vissebr=c3=a5ten?= <[email protected]>
>  >
>  > ------------------------------------
>  >
>  > ------------------------------------
>  >
>  > Yahoo Groups Links
>  >
>  >
>  >
> 
> 

-- 
Bratt og Ulent .....Snekkeri og høvleri.

Steinar Vissebråten, Liavegen 149,
N-3540 Nesbyen,NORWAY

Phone: +47 32068733..............Mobil: +47 9069 3540

Internet:
http://www.vissebraaten.no/
http://www.rukkedalen.com/


------------------------------------
Posted by: =?UTF-8?Q?Steinar_Vissebr=c3=a5ten?= <[email protected]>
------------------------------------