Number in different format

Help Activities
1

I have a data in german format in excel.
Column A Column B Column C
1.234,67 1.234,67 0,00

I want to put condition:-
If Column C <>0,00 then true else false.

My question is how to convert this values in german format and how to give condition for 0,00?

2

Hi ,

It should work with If coulmn C <> 0 , there shouldnt be any issue . was there any issue?

3

My format is different it is in german format so it should be 0,00.

4

Hi,

0,00 is still 0.

For example , in your excel , if you have applied with German separators , it will still be treated as 0.

so , in your code , you can simply cehck if ColumnC <> 0 , it should work . can you try ?

image

you can set the excel format as german

https://answers.microsoft.com/en-us/msoffice/forum/all/seperator-in-numbers-in-german/94ba78b8-2b7b-e011-9b4b-68b599b31bf5

5

Hello @Ak_4
Refer to this thread you may Get some Idea

6

No, u are getting wrong format. Try the different values where u can get the difference of 0,61.

7

Thank u for help.

8

How we can set the condition?

9

@Ak_4
Check this Xaml File
ConvertDoubleGerman.xaml (6.5 KB)

10

Hi @Ak_4

A simple walk-around I can think of, is to treat your inputs as string while processing comparison, like dtExcel(row)(column C).tostring.Equals(“0,00”) and use NOT function if required. this should simplify the processing.

Regards,
karan zaveri

11

Please can u send me the image of this. I unable to download it in my system.

12

@Ak_4
Referto this Image.

image
image952×720 36.1 KB

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.