Excel 2003 Formatting

[philb99]

Hi - I have designed a monitoring spreadsheet in which I require the team to add numeric values in 1 column - which is then added up at the bottom

Unfortunately some of the team put comments in with their figure and thus it does get included

Is there a formula that I can insert so that you can only enter figures into the column of cells.

Thanks

 

[Andrew Poulsom]

You can use Data Validation as in:

http://www.contextures.com/xlDataVal06.html#Whole

 

[philb99]

Thanks Andrew - but this takes Whole Numbers - How Can I Insert decimals in the same column. For example some returns will be 5, 100 , 34 and some will be 0.25, 0.1 or 0.75

 

[Andrew Poulsom]

There's also an option to allow Decimals.

 

[philb99]

Thanks - I can see that you can enter decimals, which will also take in whole numbers - I thought it was one or the other

 

[philb99]

Thanks for your help Andrew - I have now come to use the Decimal Function and it will not allow me to enter 0, anything else no problem. What am I doing wrong

 

[Andrew Poulsom]

What Data options did you set?

 

[philb99]

Decimal - Min 0.01 Max 5000

 

[Andrew Poulsom]

Well zero is less than the minimum of 0.01.

 

[philb99]

Thanks Andrew - I have lost the plot!! I can see what I have done now - Appreciate your patience and help