weaselmcguff
Board Regular
- Joined
- Feb 24, 2006
- Messages
- 246
I have a userform that have 5 inputs and 2 Label(Result Boxes)
1. Part number
2. Cost
3. System Count
4. Physical Count
5. What to do with the variance.
Labels as
1. Total Cost
2. Variance
I am trying to copy/transfer the data to a spreadsheet. Everything goes ok till I try and save the Total Cost to the sheet. The spreadsheet for the other cells are formatted as Currency so that format works. But with the What to do with the variance. I let them put 1 of 4 option and then it pulls that option and the total cost to the spreadsheet. Since it is text and numbers it is formated on sheet as Text. The result that shows up on the sheet is: Adjust to GL5394 - -34.44 it should be: Adust to GL5394 - -$34.44 or Adjust to GL5394 - ($34.44)
How do i get it to change it to the Currency part.
Thanks for your time.
1. Part number
2. Cost
3. System Count
4. Physical Count
5. What to do with the variance.
Labels as
1. Total Cost
2. Variance
I am trying to copy/transfer the data to a spreadsheet. Everything goes ok till I try and save the Total Cost to the sheet. The spreadsheet for the other cells are formatted as Currency so that format works. But with the What to do with the variance. I let them put 1 of 4 option and then it pulls that option and the total cost to the spreadsheet. Since it is text and numbers it is formated on sheet as Text. The result that shows up on the sheet is: Adjust to GL5394 - -34.44 it should be: Adust to GL5394 - -$34.44 or Adjust to GL5394 - ($34.44)
How do i get it to change it to the Currency part.
Thanks for your time.