| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Numbes as Text!!!!
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting Numbes as Text!!!!
Did you reopen the CSV using excel or NotePad?
I saw this in a text editor: 05/14/08,5280-3-01 05/14/08,5280-3-01 05/14/08,5280-3-01 05/14/08,5280-3-01 05/14/08,5280-3-01 05/14/08,5280-3-01 05/14/08,1030-0-01 05/14/08,1030-0-01 05/14/08,2101-0-01 05/14/08,2101-0-01 05/14/08,2101-0-01 05/14/08,2101-0-01 05/14/08,2101-0-01 05/14/08,2101-0-01 05/14/08,2101-0-01 05/14/08,2101-0-01 If you reopen the CSV file in excel, then excel will treat the data however it wants. 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. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Text in cells that already have text entered | Excel Worksheet Functions | |||
| copying text within a text box and losing formatting | Excel Discussion (Misc queries) | |||
| Calculating Max & Min in a negative numbes | Excel Worksheet Functions | |||
| Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
Linear Mode
