I am doing a calculation (Cell f7/22) - $300,000.00 divided by 22 the result shows as Zero!
G G4 Sep 20, 2005 #1 I am doing a calculation (Cell f7/22) - $300,000.00 divided by 22 the result shows as Zero!
A Anne Troy Sep 20, 2005 #2 Perhaps the $300K isn't being seen as a number. Try "Data isn't recognized..." http://www.officearticles.com/excel/data_cleanup_tips_for_microsoft_excel.htm ************ Anne Troy www.OfficeArticles.com
Perhaps the $300K isn't being seen as a number. Try "Data isn't recognized..." http://www.officearticles.com/excel/data_cleanup_tips_for_microsoft_excel.htm ************ Anne Troy www.OfficeArticles.com