| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I import fractions without data being converted to dates?
I am importing data that was created in France and they used fractions for
the inch data rather than decimals. Now, when I try to import that data, even though the preview shows it importing correctly, it converts the fractions to dates because I suppose it sees the forward slash. How do I make it recognize them as fractions and not dates? Thanks, Ray Proeber |
|
#2
|
|||
|
|||
|
Ray,
Format the column for text in the import wizard. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "rproeber" wrote in message ... I am importing data that was created in France and they used fractions for the inch data rather than decimals. Now, when I try to import that data, even though the preview shows it importing correctly, it converts the fractions to dates because I suppose it sees the forward slash. How do I make it recognize them as fractions and not dates? Thanks, Ray Proeber |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
| How do I import data from a SECURED website into Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
