= sum value turns to text and formula disappears

[Tara DAgostino]

Hello,



I have an issue. I created an Invoice spreadsheet integrated with VB
and using a form. What my project does is Opens an Excel spreadsheet.
There is a button that says: New invoice. My macro, clears all input'd
data on the sheet, changes the invoice number to the next sequential
number (1400, then goes to 1401), saves the worksheet and opens the form
attached.



The data can be inputted easier from the form to the excel spreadsheet.
On the form I have 4 buttons that create a new invoice like mentioned
above, Print the Invoice and Save the invoice.



What the save invoice does is opens another workbook that can be saved
with the name you want the invoice to be named, and so the original
invoice can always produce the next invoice number in the sequence and
no duplicates will occur.



And the forth is a clear button to start that invoice over if needed.



I have the whole project working, Except the values of hours and units.
What happens is, you enter the hours (ex. 3) and the total changes to 3,
then you add the units, (Ex. 40). So the total should be 120. Well
when I enter the hours, the =sum(E5 + F5) changes from the formula to
text and changes to just the number 3.



I have worked in excel for 10 yrs and never has an issue.



I am using Excel 2003. I just got it 2 weeks ago. So I am not sure if
it is the upgrade. I have tried everything Please help. I am figuring
I will enter the sum function in another cell off to the side and create
a macro called update to special paste the values in the correct field.
But that is really not the route I want to take.





Thanks,

Tara D'Agostino

 

[Roger Govier]

You have a reply in Excel.misc

--
Regards

Roger Govier


Hello,



I have an issue. I created an Invoice spreadsheet integrated with VB and using a form. What my project does is Opens an Excel spreadsheet. There is a button that says: New invoice. My macro, clears all input'd data on the sheet, changes the invoice number to the next sequential number (1400, then goes to 1401), saves the worksheet and opens the form attached.



The data can be inputted easier from the form to the excel spreadsheet. On the form I have 4 buttons that create a new invoice like mentioned above, Print the Invoice and Save the invoice.



What the save invoice does is opens another workbook that can be saved with the name you want the invoice to be named, and so the original invoice can always produce the next invoice number in the sequence and no duplicates will occur.



And the forth is a clear button to start that invoice over if needed.



I have the whole project working, Except the values of hours and units. What happens is, you enter the hours (ex. 3) and the total changes to 3, then you add the units, (Ex. 40). So the total should be 120. Well when I enter the hours, the =sum(E5 + F5) changes from the formula to text and changes to just the number 3.



I have worked in excel for 10 yrs and never has an issue.



I am using Excel 2003. I just got it 2 weeks ago. So I am not sure if it is the upgrade. I have tried everything Please help. I am figuring I will enter the sum function in another cell off to the side and create a macro called update to special paste the values in the correct field. But that is really not the route I want to take.





Thanks,

Tara D'Agostino