Converting decimal present in excel to digits and then doing sum of a column values

Help Studio
1

Exporting an excel file from SAP system and it’s getting values in decimal but it’s actually in digits only.
I am performing sum of column in excel and using below mentioned formula. Is there a way to tweak this formula and use it convert that decimal to digits and do sum
or before that If I can do something and then do the sum?

2

@anjasing

Use Format Cells activity to format the column as Decimal and then apply your formula for sum.

Thanks,
Ashok :slightly_smiling_face:

1 Like
Forum Engagement Daily Reports
4

Hi @ashokkarale ,

I meant in excel it’s given as 12.00 but it should be considered as 1200.
if it;s given as 15.450 the value is 15450

Can you please help with this?

5

@anjasing,

Before using Format Cells use below formula to remove the .

=SUBSTITUTE(A1,CHAR(46),"")

image
image708×109 5.54 KB

Thanks,
Ashok :slight_smile:

6

Thank you so much Ashok :slight_smile:

1 Like
7

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