LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
rajeev
 
Posts: n/a
Default Excel Calculation

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.

Thanks in advance

Rajeev

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel startup switches Randy Excel Discussion (Misc queries) 9 June 14th 05 10:27 PM
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 01:08 AM
Amortization Calculation in Excel worksheet Tiff Excel Worksheet Functions 4 January 29th 05 04:18 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"