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.
Hi @md.ahtesham
Can you try instead of double quotes like this
"_($* #,##0_);_($* (#,##0);_($* '-'_);_(@_)"
Thank you
Balamurugan.S
@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
Thank you.
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.
