Entering =6000 turns value into text '6000' HELP! I'm Stumped!

T

TWiz

This is a strange thing that happens only in this one particula
spreadsheet. If you enter =6000 the value becomes '6000'
If you enter a formula with the number 6000, this workbook treats i
like 0 (zero)

6001 works, or any other number.

Very odd. I've checked to see if there's a name '6000'
Changing the data type does not make a difference, other than lef
justifying the data.

Any ideas would be helpful
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top