behnam_tr Active Member Licensed User Longtime User Jul 14, 2021 #1 in XLutils how set cell format to Text ?? i want to write and read phone number like this : 0914****** , 0933***** , ...... after save when i want to edit phone number in excel file it changed to 914*****,933***** After editing, I can not add the number '0' to the first of the phone number i want to set cell format to TEXT thanks Attachments b4x_xlutils.png 24.6 KB · Views: 137
in XLutils how set cell format to Text ?? i want to write and read phone number like this : 0914****** , 0933***** , ...... after save when i want to edit phone number in excel file it changed to 914*****,933***** After editing, I can not add the number '0' to the first of the phone number i want to set cell format to TEXT thanks
behnam_tr Active Member Licensed User Longtime User Jul 14, 2021 #3 Solved B4X: Dim tellstyle As XLStyle = Workbook.CreateStyle.DataFormat("TEXT").HorizontalAlignment("LEFT") Last edited: Jul 14, 2021 Upvote 0
Solved B4X: Dim tellstyle As XLStyle = Workbook.CreateStyle.DataFormat("TEXT").HorizontalAlignment("LEFT")