How to format excel sheets in UNIX??

Shell Programming and Scripting
1

Hi,

I have generated an excel sheet using a shell script. i have converted the output text file to an excel and got the desired output. However, in a particular column in the excel the values of the numbers start with 0.
e.g. 078393343, 00342442, etc.

But, in the resulting excel I get as 78393343,34244.
Is there any way to format this in UNIX?
i.e is there any way to format those numbers into text values....so that the resulting spreadsheet displays correctly along with the zero.

Thanks,
Vijayakumar.

2

Format your numbers like that :

="078393343"
="00342442"

Jean-Pierre.

3

Do u mean to add special characters at the front and the end of the whole column??