This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi, I have Postal Code column and used select tool with datatype to V_WString it converted the data to string but i get the warning "Number stored as text" when i open in excel. The default type for all column once the render tools outputs the excel file become "Number" automatically even though my data is V_WString. Any solution to remove that?
I have attached the warning message and data type showing "Number" i get in excel here.
I am not writing into a CSV. I am writing it to Excel workbook .XLSX format. I am appending images and formatting using Table and Layout. So, i am using the 'Render' tool to put the excel file. This is going to be to be automated so i cannot every time open and change the excel data types.
This Postal Code is an example. I have ID's, Phone number etc which are following through as String but in the output excel file they are converted to "Number" and represented as 123,456,789 (with comma) which i don't want.
The Table tool or Render tools as far as i am understanding is outputting all columns into a 'Number' format irrespective what data type flows through it. Is there any way to change that ?