Hi,
I need to format a spreadsheet in Excel so that when it is saved as a .txt (Notepad) file it has all its columns aligned from the left side, like that displayed below.
CELLID DATE CI DROP_TCH DROP_PCT
G10041A 01/09/2008 12345 417 5 0.84 3.4
I have tried using the rept function with combinations of right and left functions but I cannot get it to work efficiently. I have attached the file. One other problem is in column D the numbers are displayed to two decimal points although the numbers themselves have up to 8 decimal points. When saving as a text file I need only the number in two decimal points or a number of points that I specify. You can see the functions I have used in Cell G1 and issues can easily be noticed. Any help is greatly appreciated.
Cheers,
Daithi
Bookmarks