Formulas that reference a cell with numbers and text

D

donnae

How do you create a formula with the end results being a dollar amount when
the cell that the formula references has numbers and text? Example: 5 Boxes
at 5.99=$29.99
 
J

Jeff Boyce

You've posted in a newsgroup dedicated to supporting Microsoft Access, the
relational database.

Database tables don't have "cells".

Do you need to post to an Excel newsgroup?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff Boyce

Excel does numbers.

Access does databases/applications.

Do you have any references to cite for why you believe "Access is better at
math"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number/Text combination formula 8
Excel How to add numbers in same cell? 2
Last Modified By in a cell by user 3
Reference Cell Altering Formulas 1
Two formulas in on cell based on two numbers in another cell? 5
Excel Sum numbers in cells that also contain text 34
Too many decimals when using =[cell reference]&"[text]" 2
Convert number to text as displayed 3

Top