Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Convertin a texte 1 000 to 1000 (2002)

    From a web site I have imported a table into excel a space is used in the separation in stead of a comma as a thousands separator. My numbers are assumed to be text instead of numbers. How can a setup a number format so that 1 000 is a 1000 and 1 000 000 is a million.

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

    Re: Convertin a texte 1 000 to 1000 (2002)

    Post deleted by wdwells
    Regards
    Don

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

    Re: Convertin a texte 1 000 to 1000 (2002)

    On second thought:
    <UL><LI>Select the range with the offending text
    <LI>Pull down Edit | Replace
    <LI>Type a single space in the Find what box
    <LI>Leave the Replace with box empty
    <LI>Click Replace All
    <LI>Click Close[/list]
    Regards
    Don

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Convertin a texte 1 000 to 1000 (2002)

    thanks but i also just found to use the thousands separator of format cells in the number tabs

Posting Permissions

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