Need help: Excel automatically change input values

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

Guest

Excel version: 2003
Symtpoms:
Whenever I input 1, excel automatically change it to 00.1.
Whenever I paste a value with a comma (",") as a deliminator, excel
automatically split it into two cells and remove the comma.

Possible cause:
The whole problem starts when I tried to split values in a column with comma
deliminators. It seems that Excel remembers this action. I have not found a
way to remove this hidden action.

What I have tried:
I have tried Tools->Options->Calculation, set Calculation on "Manual". It
has not solved the problem.
 
Thanks a lot for such a quick response. It works to solve the problem that
changes value of 1 to 0.01.

For the deliminator problem, I tried "Convert Text to Columns wizard" on one
cell, removed any deliminators there. Seems that Excel does not split the
value automatically anymore when I paste values.

Thanks again and wish you the best!
 
Sorry, I didn't even see that there was another question, I believe somehow
Excel remembers that you have used text to columns in a certain way and it
affects pasting of comma delimited data and you obviously found out the
remedy. Thanks for posting back.


--


Regards,


Peo Sjoblom
 

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

Saving Text File 1
stopping pasted text deliminate across multiple cells 3
How to remove first comma in a value 8
Formatting in formulas not allowed before commas 5
Excel 2003 automatic calculation all worksheets except one 3
Why doesn't Excel understand what 'Manual' for Calculations? 4
Import of Text Delimited file into excell 1
Moving Text from Word to Excel (and having it set into 2 columns) 4

Back
Top