auto calculate not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I import a file and paste as CSV. I believe everything is considered text
then, but there are numbers as well. The worksheet has over 4000 lines. I
try to concantenate two cells (ie. a2 and b2). I use the function, but the
result shows the formula. What I want is the new value or the string of
words. I have checked my options and the auto calculate is turned on. I
even try the various F9 keys.
 
Under 'Tools'...'options'....'window options' do you have the formulas box
checked? If so uncheck that box.
 
Did you format the row you are putting the concatenate as general before
entering the formula? (Also even numbers can be considered text if imported
as text I believe.)
 
Hi

It sounds like your cell was formatted as Text before you typed in the
formula. Format it as General and re-enter your formula.
Just because a file is CSV does not mean that all entries are treated as
text. Numbers will still remain numbers.

Andy.
 
You must log in or register to reply here.

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

Similar Threads

sumif 1
Scrabble Value calculation for Welsh words 0
Avoiding redundant calculations 7
Custom Function not being auto calculated when cells change..help? 4
Auto calculating not working 4
Calculate After hours 3
Problem calculating 3
The next Grand Theft Auto title has been officially announced 0

Back
Top