Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Why is "0.4" and ".4" suddenly different?


  • Please log in to reply

#1
Tollerowner

Tollerowner

    Member

  • Member
  • PipPipPip
  • 102 posts
I have a spreadsheet where I track the day to day changes in the S&P500 as part of a larger scheme.
It is formatted to 0.0%, so I enter the daily change. it worked just like I wanted for a year.

Until a couple days ago if the market went up .4% I would enter .4 and all would be well. Now it suddenly interprets .4 as 40%! I can get .4% by entering .004, 0.4, or even .4%; just not by .4.

What on earth is going on? Is there anyway to made it do what I want (ie. what it used to do...)
I am beginning to fear early onset dementia.

Okay, it is Excel97 if that matters. It does everything I want (well up to a couple days ago) so why change.
  • 0

Advertisements


#2
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts
Try typing in your .4 with the percent sign at the end - i.e. - .4% - see if that works.
  • 0

#3
Tollerowner

Tollerowner

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 102 posts
Yes, .4% works properly, as does 0.4, as I indicated above.

Thing is, .4 used to work properly but doesn't now.
  • 0

#4
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts
Well, I've just entered a variety of numbers onto a spreadsheet, and the only way I can get the cell to display it as .4% is by typing in either .4%, .004

Mathematically speaking .4 is NOT .4% it's 4/10 or 40%

This is what I get:

Unformatted Formatted
0.004 0.40%
0.04 4.00%
0.4 40.00%
4 4.00%
40 40.00%
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP