Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers to Text or??!!!
I have a spreadsheet that contains the following data:
Date Account ID 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 1030-0-01 5/14/08 1030-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 When I save it as a .csv file it looks like this: Date Account ID 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 1030-0-01 5/14/2008 1030-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 I have formatted it to Text, Number, and General etc. I have Copy the data into a new spreadsheet, cleared all formatting. Tried this on two different computers. No matter what it keeps changing the 2nd column to a data format. Even though it doesnt do it to the other account ID. I have imported this stuff before and no problem. I am not importing into Excel. When I open the file using notepad this is what it looks like: Date,Account ID,Reference,Trans Description,Amount,Number of Distributions,Recur Number,Recur Frequency 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8 course these are all the columns |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers to Text or??!!!
--In 2007 from menu DataFrom Text and in 2003 from menu DataImport External
DataImport Data ---select the .csv file to be opened. --From the 'Text Import Wizard' Step 1; select 'Delimited' and hit next --From the 'Text Import Wizard' Step 2; select 'Comma' and hit next (you can uncheck the other defaults selected) --From the 'Text Import Wizard' Step 3; From 'Data Preview Area' select all the columns which you would want to be displayed as text. In your case Column2. Once selected the background will be black and the text will be white. --Then on the same window from the group 'Column Data format' select Text and Hit Finish. -- Jacob "klafert" wrote: I have a spreadsheet that contains the following data: Date Account ID 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 1030-0-01 5/14/08 1030-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 When I save it as a .csv file it looks like this: Date Account ID 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 1030-0-01 5/14/2008 1030-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 I have formatted it to Text, Number, and General etc. I have Copy the data into a new spreadsheet, cleared all formatting. Tried this on two different computers. No matter what it keeps changing the 2nd column to a data format. Even though it doesnt do it to the other account ID. I have imported this stuff before and no problem. I am not importing into Excel. When I open the file using notepad this is what it looks like: Date,Account ID,Reference,Trans Description,Amount,Number of Distributions,Recur Number,Recur Frequency 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8 course these are all the columns |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers to Text or??!!!
I am using 2003- Can I do the same?
"Jacob Skaria" wrote: --In 2007 from menu DataFrom Text and in 2003 from menu DataImport External DataImport Data ---select the .csv file to be opened. --From the 'Text Import Wizard' Step 1; select 'Delimited' and hit next --From the 'Text Import Wizard' Step 2; select 'Comma' and hit next (you can uncheck the other defaults selected) --From the 'Text Import Wizard' Step 3; From 'Data Preview Area' select all the columns which you would want to be displayed as text. In your case Column2. Once selected the background will be black and the text will be white. --Then on the same window from the group 'Column Data format' select Text and Hit Finish. -- Jacob "klafert" wrote: I have a spreadsheet that contains the following data: Date Account ID 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 1030-0-01 5/14/08 1030-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 When I save it as a .csv file it looks like this: Date Account ID 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 1030-0-01 5/14/2008 1030-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 I have formatted it to Text, Number, and General etc. I have Copy the data into a new spreadsheet, cleared all formatting. Tried this on two different computers. No matter what it keeps changing the 2nd column to a data format. Even though it doesnt do it to the other account ID. I have imported this stuff before and no problem. I am not importing into Excel. When I open the file using notepad this is what it looks like: Date,Account ID,Reference,Trans Description,Amount,Number of Distributions,Recur Number,Recur Frequency 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8 course these are all the columns |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers to Text or??!!!
Sorry just saw for 2003 - going to try it now - in the end I need to import
that .csv file. "klafert" wrote: I am using 2003- Can I do the same? "Jacob Skaria" wrote: --In 2007 from menu DataFrom Text and in 2003 from menu DataImport External DataImport Data ---select the .csv file to be opened. --From the 'Text Import Wizard' Step 1; select 'Delimited' and hit next --From the 'Text Import Wizard' Step 2; select 'Comma' and hit next (you can uncheck the other defaults selected) --From the 'Text Import Wizard' Step 3; From 'Data Preview Area' select all the columns which you would want to be displayed as text. In your case Column2. Once selected the background will be black and the text will be white. --Then on the same window from the group 'Column Data format' select Text and Hit Finish. -- Jacob "klafert" wrote: I have a spreadsheet that contains the following data: Date Account ID 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 1030-0-01 5/14/08 1030-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 When I save it as a .csv file it looks like this: Date Account ID 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 1030-0-01 5/14/2008 1030-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 I have formatted it to Text, Number, and General etc. I have Copy the data into a new spreadsheet, cleared all formatting. Tried this on two different computers. No matter what it keeps changing the 2nd column to a data format. Even though it doesnt do it to the other account ID. I have imported this stuff before and no problem. I am not importing into Excel. When I open the file using notepad this is what it looks like: Date,Account ID,Reference,Trans Description,Amount,Number of Distributions,Recur Number,Recur Frequency 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8 course these are all the columns |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers to Text or??!!!
That didn't work exactly. I can get it in .xls I need to have in the .csv
file so I can import the data. I have before with no problems using this account number. I don't have to open the .csv I just have to import it into another program not Excel. "Jacob Skaria" wrote: --In 2007 from menu DataFrom Text and in 2003 from menu DataImport External DataImport Data ---select the .csv file to be opened. --From the 'Text Import Wizard' Step 1; select 'Delimited' and hit next --From the 'Text Import Wizard' Step 2; select 'Comma' and hit next (you can uncheck the other defaults selected) --From the 'Text Import Wizard' Step 3; From 'Data Preview Area' select all the columns which you would want to be displayed as text. In your case Column2. Once selected the background will be black and the text will be white. --Then on the same window from the group 'Column Data format' select Text and Hit Finish. -- Jacob "klafert" wrote: I have a spreadsheet that contains the following data: Date Account ID 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 1030-0-01 5/14/08 1030-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 When I save it as a .csv file it looks like this: Date Account ID 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 1030-0-01 5/14/2008 1030-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 I have formatted it to Text, Number, and General etc. I have Copy the data into a new spreadsheet, cleared all formatting. Tried this on two different computers. No matter what it keeps changing the 2nd column to a data format. Even though it doesnt do it to the other account ID. I have imported this stuff before and no problem. I am not importing into Excel. When I open the file using notepad this is what it looks like: Date,Account ID,Reference,Trans Description,Amount,Number of Distributions,Recur Number,Recur Frequency 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8 course these are all the columns |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers to Text or??!!!
Check one of your other 100 posts.
klafert wrote: I have a spreadsheet that contains the following data: Date Account ID 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 1030-0-01 5/14/08 1030-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 When I save it as a .csv file it looks like this: Date Account ID 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 1030-0-01 5/14/2008 1030-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 I have formatted it to Text, Number, and General etc. I have Copy the data into a new spreadsheet, cleared all formatting. Tried this on two different computers. No matter what it keeps changing the 2nd column to a data format. Even though it doesnt do it to the other account ID. I have imported this stuff before and no problem. I am not importing into Excel. When I open the file using notepad this is what it looks like: Date,Account ID,Reference,Trans Description,Amount,Number of Distributions,Recur Number,Recur Frequency 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8 course these are all the columns -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers to Text or??!!!
I am so sorry - yesterday when I was posting it didn't appear if the post
went through. Until early am this morning I couldn't view them for some reason. "Dave Peterson" wrote: Check one of your other 100 posts. klafert wrote: I have a spreadsheet that contains the following data: Date Account ID 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 1030-0-01 5/14/08 1030-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 When I save it as a .csv file it looks like this: Date Account ID 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 1030-0-01 5/14/2008 1030-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 5/14/2008 2101-0-01 I have formatted it to Text, Number, and General etc. I have Copy the data into a new spreadsheet, cleared all formatting. Tried this on two different computers. No matter what it keeps changing the 2nd column to a data format. Even though it doesn€„¢t do it to the other account ID. I have imported this stuff before and no problem. I am not importing into Excel. When I open the file using notepad this is what it looks like: Date,Account ID,Reference,Trans Description,Amount,Number of Distributions,Recur Number,Recur Frequency 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,, 5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8,, 5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,, 5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,, 5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,, 5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8 course these are all the columns -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Numbers as Text!!! | Excel Worksheet Functions | |||
Formatting numbers as text | Excel Discussion (Misc queries) | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
Formatting from text to numbers | Excel Worksheet Functions | |||
numbers to text with formatting | Excel Discussion (Misc queries) |