Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Location
    Stoke on Trent, Staffordshire, United Kingdom
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Saving a format cell custom setting (Excel 2003)

    Is there a save command / option anywhere in Excel that saves the custom format entry. For example, an internet based system my employer now uses in the course of our business allows me to upload account code details in a csv format, as we modify / add account codes to that system, the saved file stored locally loses the custom format and we have to re format the cell with the custom formula to re upload any amendments. <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45> Hope someone out there can help. its driving us nuts!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Saving a format cell custom setting (Excel 2003)

    A .csv file is a plain text file, not a real Excel workbook. Plain text files do not store formatting information or formulas.

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Saving a format cell custom setting (Excel 2003)

    Hi Tony
    Welcome to the Lounge.
    It appears to me that you are modifying the csv file to your presentation needs and replacing that file with each new version of the csv data. One alternative approach would be to create a Master workbook with a worksheet containing the parsed csv data, and another sheet that is formatted in the manner you want, which refers to the parsed csv data.
    On receipt of new data:
    1. <LI>Open the new csv file
      <LI>Ensure that it is parsed in the same manner as your csv data in your Master workbook
      <LI>Copy the entire worksheet
      <LI>Select the entire csv worksheet in your Master workbook
      <LI>From the menu bar Pull down Edit | Paste Special
      <LI>Select Values
      <LI>Click OK
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •