Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    trailing letters on numbers imported from other ap (2000)

    Problem: When I import numbers from certain sources, they have a trailing letter that has some signifigance within the source from which I cut and paste the figures. For example, a price of $5.000 in my source might show up as $5.000y, with the "y" signifying the price is a settlement or closing price. The problem is that when I paste these numbers into a spreadsheet, with the trailing letters, Excel reads them as text. When I try the Left(A!,4) function, I can't display a $ when I want the figures to appear as accounting format. As a result, to get the accounting format with 3 decimal places and the $ sign, I am forced to go into each imported number and manually remove the "y", a long and tedious process when many numbers are involved.
    Any suggestins?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: trailing letters on numbers imported from other ap (2000)

    I would do this:

    - select all offending cells
    - open search and replace (control-h), enter y in the first box and click replace all
    - open search and replace (control-h), enter $ in the first box and click replace all
    - format the cells as currency.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: trailing letters on numbers imported from other ap (2000)

    Jan,
    Works like a charm-I thought I had tried that previously, but obviously not!
    Thanks,
    Jeff

Posting Permissions

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