I have a dummy file attached for reference. I downloaded a file with data for yearly demand from a customer. I added a column to sum the monthly totals. As you can see in E6, the formula shows "=sum(h6:s6)" Is there a way to turn on the function so it works and reads "30." The file is not read only and I did rename and save it.
Thanks.
Last edited by NBVC; 09-20-2011 at 06:53 AM.
You have the column Formatted as TEXT... change format to General or Number and then go to E6, Hit F2 and Enter...
continue on...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
The cell is formatted as Text. Change the format to General, then press F2 and Enter ... you don't need to change anything else.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Your cell is formatted as Text. Change that to General and then go into the formula bar (or press F2) and hit enter. Did that work?
EDIT: Third times the charm. LOL
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes, Thanks! I guess I was assuming it was something harder than it needed to be since I downloaded the data.
Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks