Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi all,

    I have a CSV file that i import the data onto a payroll system. Before I import the data on one of the columns I put three zeros in front of numbers and I use the following formula ="000" & B on a different cell i.e. f2, I then copy paste values on cell b2. this displays the zeros before the numbers on Column./ cell B2. I than save the file it gives me a few warning and click yes to those, etc. and usually when I open the file the zeros are there, but this time they are all gone.

    Does anyone know what the problem is?

    Cheers

  2. #2
    Super Moderator BATcher's Avatar
    Join Date
    Feb 2008
    Location
    A cultural area in SW England
    Posts
    3,420
    Thanks
    33
    Thanked 195 Times in 175 Posts
    Me, I'd check how your cell(s) is/are formatted...
    BATcher

    Time prevents everything happening all at once...

  3. #3
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How should the cells be?

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    How are you opening the file to check? In Excel or Notepad (or some other text editor)?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by skender View Post
    Hi all,

    I have a CSV file that i import the data onto a payroll system. Before I import the data on one of the columns I put three zeros in front of numbers and I use the following formula ="000" & B on a different cell i.e. f2, I then copy paste values on cell b2. this displays the zeros before the numbers on Column./ cell B2. I than save the file it gives me a few warning and click yes to those, etc. and usually when I open the file the zeros are there, but this time they are all gone.

    Does anyone know what the problem is?

    Cheers
    I believe that Excel have converted text to number automatically.
    Why don't you try custom formatting your cell, it is much more robust
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Posting Permissions

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