The excel "Amount" Column I had convert to Number, however, it display as text, and it cannot sum when I create pivot table, who can help me solve this issue?

Help Studio
, ,
1

Requirement:
I have one excel which download from Oracle and I save as excel, the data display text format however they are general format, and I had convert “Amount” column to Number , my issue is when i use the data source create pivot table, it can not sum amount, I need you help. thanks.

image
image1049×656 42.9 KB

image

Test_176887620.xlsx (13.4 KB)

2

Hello @Lori ,

Please refer to this thread :

3

@rohith.prabhu
Thanks for you reply, which need enable Macro, any other method can solve this issue?
is studiox can solve this issue?

4

Hello @Lori ,

There are few other methods :

  1. Use Format Cell
    https://docs.uipath.com/activities/docs/format-range-x

  2. Use Custom Activity by BalaReva
    UiPathGo - BalaReva Excel Activities - #15 by balupad14

1 Like
5

@rohith.prabhu

I had tried use format cell and failed.

image

6

@Lori ,

So After format cell you are getting values in Number format in the given sheet (Sheet1)? Also Can you check once your pivot table and confirm everything is correct.

7

After Format Cell, when I click right mouse and click “Format Cell” and found the column had format as number as top topic screenshot, however, it still display as text feature, and when create pivot table, it still cannot sum.

8

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