Formula turns into text after entering in the first value.

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

Hi Tara
It sounds as though the column holding your units has been formatted as text.
Reformat the column with Formats>Cells>Number>General or Number to the correct decimal places you require.
In a blank cell (formatted general) type a 1. Copy the cell. Mark your block of data holding the units and Paste Special>Multiply.
This will convert all previously entered values to numeric, and hopefully your problem will disappear.

--
Regards

Roger Govier


"Tara DAgostino" <[email protected]> wrote in message news:000501c61e2b$894204b0$040aa8c0@starshiner...
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