Excel data formatting

Hi Team,

This is very easy question but still want to know what could different way to do it.

I have excel like below

When i append data from other sheet then formatting is not same as per above and looks something like below…

What could be best approach to fix this…? any suggessation. or is there any shortcut key to align data like above ?/

Ahtesham

Hi @md.ahtesham,

Here is the link that you can change the format of the cell range.

Regards
Balamurugan.S

Hi @md.ahtesham,

check the PreserveFormat property while reading the data using read range activity.

Regards.

1 Like

I am getting below error :

Any idea, how to fix ?

Ahtesham

1 Like

Hi @md.ahtesham

Can you try instead of double quotes like this

"_($* #,##0_);_($* (#,##0);_($* '-'_);_(@_)"

Thank you
Balamurugan.S

1 Like

@balupad14 I am not so good at excel , it will be very nice if u can help me understated the expression u derived

(* #,##0_);_(* (#,##0);($* ‘-’);(@_)”

from my expression.
-* #,##0-;-* #,##0_-;-* “-”??-;-@-”

It will be very helpful if you can provide link from where i could learn and explore this .

Thanks,
Ahtesham

1 Like

Hi @md.ahtesham,

May be it will help you.

Reards
Balamurugan.S

Thank you.

1 Like

HI Bala,

How to get the negative numbers in red color. Will the Change cell type work from your custom activities?
I have tried the K column with 1234.10 cell type format, but not getting the desired format. Attached the output.

image