# Excel column format change **URL:** \ **Category:** Help\ **Tags:** excel, activities\ **Created:** [July 20, 2018, 7:12am UTC](https://forum.uipath.com/t/excel-column-format-change/53121 "2018-07-20T07:12:45Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![SagarSB](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sagarsb/32/176935_2.png) [@SagarSB](https://forum.uipath.com/u/SagarSB)\ **Post date:** [July 20, 2018, 7:12am UTC](https://forum.uipath.com/t/excel-column-format-change/53121/1 "2018-07-20T07:12:45Z")
Hi All, While adding values to excel column , after successfully run the bot , in result column i am not able to see result which is of number format, because that column default format is Date. So how can we change or set column format using UiPath. Please help.. ---
**Author:** ![Senthilkumar55](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/senthilkumar55/32/497170_2.png) [@Senthilkumar55](https://forum.uipath.com/u/Senthilkumar55)\ **Post date:** [July 20, 2018, 7:45am UTC](https://forum.uipath.com/t/excel-column-format-change/53121/2 "2018-07-20T07:45:11Z")
Hi @SagarSB, Try this sequence. [Change column format.zip](https://global.discourse-cdn.com/uipath/original/3X/0/7/072f909bbfeedf3e2c2901629df104ff5c875cb1.zip) (6.8 KB) ---
**Author:** ![SagarSB](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sagarsb/32/176935_2.png) [@SagarSB](https://forum.uipath.com/u/SagarSB)\ **Post date:** [July 20, 2018, 7:46am UTC](https://forum.uipath.com/t/excel-column-format-change/53121/3 "2018-07-20T07:46:22Z")
@Senthilkumar55 I will try and let you know ---
**Author:** ![yunglinchang](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@yunglinchang](https://forum.uipath.com/u/yunglinchang)\ **Post date:** [November 21, 2018, 2:05am UTC](https://forum.uipath.com/t/excel-column-format-change/53121/4 "2018-11-21T02:05:04Z")
wanna know if there is any update in this? tks! ---
**Author:** ![Bharat\_Kumar](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/bharat_kumar/32/5287_2.png) [@Bharat\_Kumar](https://forum.uipath.com/u/Bharat_Kumar)\ **Post date:** [March 25, 2019, 10:22am UTC](https://forum.uipath.com/t/excel-column-format-change/53121/5 "2019-03-25T10:22:24Z")
Can you please try ChangeFormat activity from [https://go.uipath.com/component/excel-extension-activities](https://go.uipath.com/component/excel-extension-activities) and let me know if this helps. Thanks! ---
**Author:** ![mohammedamaan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mohammedamaan/32/53965_2.png) [@mohammedamaan](https://forum.uipath.com/u/mohammedamaan)\ **Post date:** [July 17, 2019, 1:13pm UTC](https://forum.uipath.com/t/excel-column-format-change/53121/6 "2019-07-17T13:13:09Z")
How can I format the entire row or column or sheet? ---
**Author:** ![Bharat\_Kumar](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/bharat_kumar/32/5287_2.png) [@Bharat\_Kumar](https://forum.uipath.com/u/Bharat_Kumar)\ **Post date:** [July 20, 2019, 11:30am UTC](https://forum.uipath.com/t/excel-column-format-change/53121/7 "2019-07-20T11:30:19Z")
Use Select range activity followed by change format activty. ---
**Author:** ![Inspiringtec](https://avatars.discourse-cdn.com/v4/letter/i/c0e974/32.png) [@Inspiringtec](https://forum.uipath.com/u/Inspiringtec)\ **Post date:** [April 25, 2020, 6:27am UTC](https://forum.uipath.com/t/excel-column-format-change/53121/8 "2020-04-25T06:27:41Z")
@Bharat_Kumar, This is only formatting cell “G1” and not the entire column. ![image](https://global.discourse-cdn.com/uipath/original/3X/2/4/24ed07b5936d1b299969944fc7cb4417346e377e.png) ---
**Author:** ![hbpe](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/hbpe/32/185106_2.png) [@hbpe](https://forum.uipath.com/u/hbpe)\ **Post date:** [April 30, 2020, 1:57pm UTC](https://forum.uipath.com/t/excel-column-format-change/53121/9 "2020-04-30T13:57:22Z")
Hello! I’m late to the party here, but I have found that using WriteRange rather than ExcelWriteRange preserves leading 0’s as the column in Excel is treated as text rather than a number. Of course, this means you have to write the spreadsheet outside of an Excel Application Scope. Best, Peter ---
**Author:** ![fairymemay](https://avatars.discourse-cdn.com/v4/letter/f/ecd19e/32.png) [@fairymemay](https://forum.uipath.com/u/fairymemay)\ **Post date:** [February 22, 2022, 12:00pm UTC](https://forum.uipath.com/t/excel-column-format-change/53121/10 "2022-02-22T12:00:32Z")
@Inspiringtec If I want use column name in range. (Column name = Other) How to write it?