|
|
|
|
#1
11-23-2014, 08:43 AM
|
|||
|
|||
I'm still curious, but thanks!
Though it is not exactly what I wanted, it will work. I just have to adjust the formula a little to fill the leading zeroes, but it is no problem.
This solution answer my need, but my curiosity really thrives to understand what does lead excel to the original misinterpretation.  Thanks for your time! Your answer is a fair solution to my problem!  
|
|
#2
11-23-2014, 09:29 AM
|
|||
|
|||
Hi,
On Excel, numbers must conform to IEEE 757 standards of 15 characters or less, any digit beyond 15 is replaced by "0". That's why you need to treat numbers with more that 15 chars as text.
|
|
| Tags |
| number formatting |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Number List Problem!
|
Mole Patrol | Word | 2 | 09-18-2013 11:46 AM |
|
Mailing: how to make the "page number" in Word is the same as "row number" in excel w
|
Jamal NUMAN | Word | 1 | 09-03-2011 11:37 AM |
|
Page Number problem
|
lugibson | Word | 3 | 08-12-2011 03:45 AM |
|
Problem with of Number of pages
|
ilkks | Word | 3 | 05-25-2011 02:27 PM |
| Number of lines on page problem | JamesT | Word | 0 | 08-27-2009 04:52 PM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode