Importing Data

R

rajeev

Hi
I am importing data to excel from other windows which is in the
following format:-
2,100
22,000
2,32,000
& so on
When i do mathematical calculation on 2,100 & 22,000 it is ok but when
i work
on 2,32,000 it says #VALUE!i.e any number having more then two or more
then two commas.
Why i am getting this effect.
I tried by going to format cell then number but there is no change.

Thanks in advance

Rajeev Chadha
 

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

Excel Calculation 9
Excel does not accept text format! 0
Inconsistent formatting of section numbers 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Appending an existing table with imported Excel data 0
Convert $ to actual numbers in an imported web query 1
Publisher 2010 insert page break and importing Word docs 2
Confusion over where user templates are stored in Word 1

Top