Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Max decimal places
Does MS Excel have a maximum number decimal places. I know that I can format
up to 30 decimal places. (This is not a formatting question.) Is 30 the default or are the decimal places infinite? I am uploading a file to a database and want to set the field length on the database to the maximum possible decimal places as long as its not infinite. Thank You. |
#2
|
|||
|
|||
Excel only supports 15 significant digits. Anything beyond that
is no mans land. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "SusieQ" wrote in message ... Does MS Excel have a maximum number decimal places. I know that I can format up to 30 decimal places. (This is not a formatting question.) Is 30 the default or are the decimal places infinite? I am uploading a file to a database and want to set the field length on the database to the maximum possible decimal places as long as its not infinite. Thank You. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Finding Values With more than 2 decimal Places | Excel Discussion (Misc queries) | |||
decimal places within a formula | Excel Discussion (Misc queries) | |||
Changing default decimal places | Excel Discussion (Misc queries) | |||
goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) |