Hi Bala! First, fantastic set of activities, very helpful! I am using the “Change Cell Type” activity to change the format to “#,##0.00_);[Red](#,##0.00)”, which it is doing for the range indicated.
However, just before I do the change, I am writing some numbers (as strings) to the range. When I go back to the workbook, the format is updated, but those cells that were updated with a value in the previous step are still a “text as a number” format. As soon as I change the value or do a hard return, the format changes to the one set. Any thoughts why this is happening?
The $0.00 values were previously “general” format and updated correct, but the ones boxed in red were the ones updated in my prior step.