RE: showing leading zeros in CSV
That's what I do for UPC codes... (Stick a single quote in front). Or do you mean ' vs ` ? Does one work different than the other when importing into Excel? I'd use the standard apostrophe, not the back one, but you can use any character that's easy to strip off (if you don't want to use Excel) It's only Excel that does the annoying number stuff Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: showing leading zeros in CSV
The reason I ask (and this is for excel specifically) is that if you check a field that you've formatted to text, Excel actually puts a single quote in front of the value (you can see it in the contents of the cell in the bar at the top of the spreadsheet. I thought if you used one over the other (which is the native Excel one), that you wouldn't have to strip it out in Excel, since it would already hide it... That's what I do for UPC codes... (Stick a single quote in front). Or do you mean ' vs ` ? Does one work different than the other when importing into Excel? I'd use the standard apostrophe, not the back one, but you can use any character that's easy to strip off (if you don't want to use Excel) It's only Excel that does the annoying number stuff Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: showing leading zeros in CSV
The reason I ask (and this is for excel specifically) is that if you check a field that you've formatted to text, Excel actually puts a single quote in front of the value (you can see it in the contents of the cell in the bar at the top of the spreadsheet. I thought if you used one over the other (which is the native Excel one), that you wouldn't have to strip it out in Excel, since it would already hide it... True, but what if you want to take it to Access or SQL Server? The apostrophe would have to be stripped Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: showing leading zeros in CSV
Yes, that's true, whether you used the native Excel single quote or not. My question is really which one of the two ' or ` is the native one, if either at all? The reason I ask (and this is for excel specifically) is that if you check a field that you've formatted to text, Excel actually puts a single quote in front of the value (you can see it in the contents of the cell in the bar at the top of the spreadsheet. I thought if you used one over the other (which is the native Excel one), that you wouldn't have to strip it out in Excel, since it would already hide it... True, but what if you want to take it to Access or SQL Server? The apostrophe would have to be stripped Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: showing leading zeros in CSV
Yes, that's true, whether you used the native Excel single quote or not. My question is really which one of the two ' or ` is the native one, if either at all? If memory serves, it's ', but the simple answer is to try both g Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: showing leading zeros in CSV
I am looking for a way to show numeric values in a csv file preserving leading zeros. For instance, say someone's ssn is 005353828 I want it to show up that way instead of 5353828. Anyone out there have any nuggets of wisdom to do this in excel? Stick an apostrophe in front of it... But if you import it into anything else, you'll have to strip it off Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: showing leading zeros in CSV
You can do it using the mso-styles. In the cell with the number with leading zeros, do this: td style=mso-number-format:#ssn#/td There are a lot of these implicitly understood styles for microsoft programs. The easiest way to find the one you're looking for is to do a bit of reverse engineering - create an excel file formatted the way you want it, then save it as html. Now, look at the code. Quite informative! -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: showing leading zeros in CSV
That will work if you copy and paste from the browser to excel, but I am looking to see if there is a way to get that result when giving the user a true CSV file. There are a few potential workarounds that require effort on the part of the user. I want it to be more like pre-school level where they can just download the file and double-click it and have it work __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: showing leading zeros in CSV
Hm Are you referring to my comments? You can set it up as a table and have it open in excel. It's not a true CSV file. But, if the end goal is formatted excel, why do you care if it's a true csv file. There wouldn't be any cutting and pasting for the end user. They'd just download a file that is formatted with html, but appears like a regular ol' excel file. -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: showing leading zeros in CSV
That's what I do for UPC codes... (Stick a single quote in front). Or do you mean ' vs ` ? Does one work different than the other when importing into Excel? I am looking for a way to show numeric values in a csv file preserving leading zeros. For instance, say someone's ssn is 005353828 I want it to show up that way instead of 5353828. Anyone out there have any nuggets of wisdom to do this in excel? Stick an apostrophe in front of it... But if you import it into anything else, you'll have to strip it off Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
