In Excel when I type 1500 in a cell it changes the 1500 to 816. WHY??

0 ⤊

In Excel when I type 1500 in a cell it changes the 1500 to 816. WHY??

It only happens at 500 increments. 499 stays 499.

2007-05-31 06:32:29 · 3 answers · asked by Timdown 1 in Computers & Internet ➔ Software

3 answers

That's a weird one.
My suggestion is to type 1500 in a different cell...one that DOES work OK. Then just click, copy, and paste that cell over the one you want. That should do it.
Good luck.

2007-05-31 06:39:03 · answer #1 · answered by KOKOMOJO 6 · 0⤊ 0⤋

Go to the cell.
Hit +1
Change format to "General" or "Number"

If that doesn't work you either have a faulty version of Excel, or you have a hardware problem.

Assuming it is a licensed copy, contact Microsoft and generate a ticket.

2007-05-31 06:46:34 · answer #2 · answered by jcurrieii 7 · 0⤊ 0⤋

it has a format check what it is ?

2007-05-31 06:40:37 · answer #3 · answered by John P 2 · 0⤊ 0⤋