http://www.developerbarn.com/ Learn helpful tips and tricks to get the best out of Office suite, using Excel, Word, PowerPoint and more. Discuss how to automate repetitive tasks and more. en Mon, 06 Sep 2010 12:42:32 GMT vBulletin 60 http://www.developerbarn.com/images/misc/rss.png http://www.developerbarn.com/ http://www.developerbarn.com/microsoft-office/2224-stubborn-csv-file-refuses-accept-text-format.html Fri, 20 Aug 2010 17:47:59 GMT I have a CSV file that contains a zip code. Some zip codes beginning with zero appear as four digits instead of five. So I attempted to use the... I have a CSV file that contains a zip code. Some zip codes beginning with zero appear as four digits instead of five. So I attempted to use the TEXT(R2,"00000") formula to force the format. Doing this produced the following result:

1. Text appears correctly.
2. File is verified as saved (including a change in the last modified date).
3. When file is re-opened, changes are gone.

I also attempted to format a column as text FIRST then paste the values of the formula into the new column and the format STILL did not hold. The only thing that forces it is a single quote, but I cannot leave a single quote in my zip codes.

Any ideas? ]]> Microsoft Office Lauramc http://www.developerbarn.com/microsoft-office/2224-stubborn-csv-file-refuses-accept-text-format.html http://www.developerbarn.com/microsoft-office/2219-obtaining-values-web-pages-excel.html Thu, 19 Aug 2010 11:59:34 GMT Hey, Ive created a calculator that is based on values from other cells. Is there a way to get values from web pages? I want to get values from 5... Hey,

Ive created a calculator that is based on values from other cells. Is there a way to get values from web pages? I want to get values from 5 universities who do similar courses and get the entry requirements. But I don't want to check every single web page for the values. Also they are known to change the requirements, so it would be good to get them onLoad when the spreadsheet opens sort of thing... :confused:

Any ideas or am i just being lazy? ]]> Microsoft Office Centurion http://www.developerbarn.com/microsoft-office/2219-obtaining-values-web-pages-excel.html