"####",s in Excel

Aka Long Numbers in Excel

By Laura Noble

 
When Excel calculates values, often the results appear as a series of "####"'s as shown in sample below.

The series of pound signs (#) indicate the column width is too narrow to fit the value. This can be corrected by decreasing the font size, decreasing the decimal places or widening the column.

Printer Friendly Version

Published in Networking Today, September 2002

 

Home    Why NSS?    Tips & Tricks   Overview    Course Topics    Contact NSS   Training Rates  Media Room  Privacy

Copyright 2000-2008. Noble Software Solutions, London, Ontario, Canada. All Rights Reserved.

Logo Designed by Elly Fox Graphic Designer