Sample Header Ad - 728x90

CSV output for Number data

0 votes
2 answers
108 views
Below is a tab delimited sample. When I open this file with notepad it looks good for numbers. But if I open it with excel, numbers do not look correct. They look +11 at the end but inside if I double click data is correct. I want to see the actual values instead of +11 at the end, if I use excel spreadsheet. I don't want to manually change format of the cells to text and see the value (or) change format to numbers and see the data. That would be manual approach. I want this to be automated. When a file is generated as file.csv from Informatica powercenter and opened in Excel the numbers should look correct without having to double click the cells. Can this be done with Unix script? I would be happy with xlsx format if it is not possible with csv. Name Number address pin John 23435435 usa 235 Jacob 2342342 india 234 Jack 35345345 uk 345 Jet 3234234 canada 323 jub 234234 australia 366
Asked by codecheck123 (1 rep)
Oct 18, 2023, 08:20 PM
Last activity: May 11, 2024, 07:39 AM