| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formatting Number 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting a number as accounting in a text reference. | Excel Discussion (Misc queries) | |||
| Formatting from Number to Text | Excel Discussion (Misc queries) | |||
| formatting number value to text value in excel | Excel Worksheet Functions | |||
| Text Function with Different Formatting for Number | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Threaded Mode
