Importing csv file values as text — OZONE Asylum, home of the Mad Scientists

FAQ

Importing csv file values as text

This page's ID: 23491

You are editing "Importing csv file values as text"

Who can edit an FAQ?	Anyone registered may edit an FAQ.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	The specific problem: Getting a csv file with the following data to display the data as text: 1.234%,12.433%,1.2% Ordinarily, Excel would convert the values to percentages and display it with the standard percentage format (2 decimal places). The solution: In order to get excel to recognize the data as text, use the following format: ="1.234%",="12.433%",="1.2%" Make sure that there are no space between the = and the first " Relevant thread: [url=http://www.ozoneasylum.com/23206]http://www.ozoneasylum.com/23206[/url] [small](Created by [internallink=793]silence[/internallink] on 09-30-2004 09:37)[/small] Loading...
Options:	Enable Slimies Enable Linkwords

« Backwards — Onwards »

Show Forum Drop Down Menu