Results 1 to 3 of 3

Thread: Heeeeeelp!!!

  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Question Unanswered: Heeeeeelp!!!

    I have datas like this: -5.30E-05
    which is supposed to mean -0.000053, right?

    But my excel refuses to see it as a number, I tried everything I knew, but nothing worked. The format doesn't change anything...

    How can I force Excel to recognize it as a number? I won't change it manually to -0.000053, I have more than 12,000 number like this...

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Welcome to the Board!

    Have you checked your column width? Expand it until you see your # shown fully and I think you'll be ok.

    Hope that helps,

    Smitty

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    Somebody found the solution this morning. It was the regional parameters of my computer, it didn't recognize the " . " in the number, so it saws it as text.

    Thanks anyway!

Posting Permissions

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