Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

FIXED(number,decimals,no_commas) formats a number as text with a fixed number of decimals

Input the formula: =FIXED(A2, 1)