Posted to microsoft.public.excel.programming

Roman[_4_] Roman[_4_] is offline

external usenet poster

Posts: 93

Excel limitation or bug or what?

Thanks for any help on this "mystery"
I have these 'numbers' in an area $A$1:$A$15 as text:
712032100100005419
712132120100006097
712132120300006097
712132120400006097
712132122100006097
712132122200006097
712132122300006097
712132122400006097
712132122500006097
712132122600006097
712132122700006097
712132122800006097
712132127700006097
712132128800006097
712132129900006097

Result of this function is 1:
=COUNTIF($A$1:$A$15;"712132120300006417")

Does anybody know why? The number is not there at all!!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 Row Limitation	NPVSRUS	New Users to Excel	5	February 12th 09 10:42 PM
Excel Limitation	Ian	Excel Discussion (Misc queries)	2	February 10th 06 07:43 PM
A version of excel that doesn't have 15 limitation	Kimjo	Excel Worksheet Functions	4	February 18th 05 03:16 AM
Excel Limitation	Farhan	Excel Worksheet Functions	1	February 11th 05 08:33 AM
excel workbook limitation	Joe Ng	Excel Discussion (Misc queries)	1	December 28th 04 07:02 PM

All times are GMT +1. The time now is 03:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us