CFCONTENT preserve leading 0's in excel

Posted on 2006-05-18
Last Modified: 2013-12-24
I am exporting data to an excel worksheet and i need to preserve the leading 0's in numeric data (all data should be strings in output), i added an apostrophe (') to teh output, but i shows up on the excel document

i need

to remain a string but what i am gettiing is

how can i specify that the output is to be a string, note i cannot use a template as teh fields are selected by teh user and i cannot guarantee which fileds will be selected.

Question by:Jester_48
    LVL 9

    Accepted Solution

    Put a    in front of the variables name that has the leading zero

    This should work for you
    LVL 24

    Author Comment

    was supposed to be a 250pt q

    but what you said worked


    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
    When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now