Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-23-2014, 09:29 AM
Catalin.B Catalin.B is offline Problem with Excel number masks Windows Vista Problem with Excel number masks Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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.
Reply With Quote
 

Tags
number formatting



Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Excel number masks Number List Problem! Mole Patrol Word 2 09-18-2013 11:46 AM
Problem with Excel number masks 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
Problem with Excel number masks Page Number problem lugibson Word 3 08-12-2011 03:45 AM
Problem with Excel number masks 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft