| 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 |
| 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) | |||
Threaded Mode
