* become X

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to Represent * (multiple) as X

eg 10mm * 10mm = 100mm ==> 10mm X 10mm = 100mm

People usually use X for multiple not *.

How to solve?

Thanks
 
Kenny,
People usually use X for multiple not *.
Click to expand...
Not with computers they don't.

This concatenation would visually yield what you asked for...
= "10mm * 10mm =" & (10*10) & "mm"

Al Camp
 
Thanks for the answer

But what i really want is :

* become X

i dont want to use the symbol * but i want to X instead

is it possible ==> (11 X 11 = 121) instead of (11 * 11 = 121)
 
Not that I normally worry about this since users should learn but you can
try:

?Eval( Replace("10 X 10", "X", "*" ) )
100
 
Do you want this to happen on a form? You could put each value into its own
text box, and put a label between them to show the x.
 
Kenny,
Why are you worried about the * in your "actual" calculations? Your
users shouldn't be seeing your formulas anyway... only the results. If you
must display the formula, my solution would do that, without the user seeing
any * at all.

I think it's you who doesn't want to see the *, and you're spending a lot
of time on what is, in my opinion, a really an inconsequential problem.
You, and your users, should be able to understand the * with no trouble at
all.

All computer programs that I'm aware of use the * for multiplication.
Are you planning to change all those too? (Word, Excel, etc...)

Perhaps Van Dinh's solution will work for you... but I have to say that
your "spitting into the wind" on this one.

Nothing personal... I want to help... and that's my opinion.

Al Camp
 
Al,

the question included the example:

eg 10mm * 10mm = 100mm ==> 10mm X 10mm = 100mm

Now considering these are measurements, I think it safe to assume that he
wishes to convert the * to X so as to keep with industry standards.

When you go into a DIY store, you don't see written on packs of wooden
flooring 10*10 : covers 100^2

You see 10mx10m : Covers 100m2

I whole heartedly agree about teaching users new things, but only if those
teachings are going to become universal to them - and this would not.
 
John,
Yes, and upon review, I see where the problem may lie...
I replied initially with this...
This concatenation would visually yield what you asked for...
= "10mm * 10mm =" & (10 * 10) & "mm"
Click to expand...

I mistyped, and it should have read...
This concatenation would visually yield what you asked for...
= "10mm X 10mm = " & (10 * 10) & "mm"
Click to expand...

I think this is what Kenny wanted all along.
But... when he said my solution wouldn't do, I thought he was referring to
replacing the * in the (10 * 10) portion of the concatenation... which no
one would ever see.
It was then that I questioned what he was trying to do. I didn't realize I
had made the typo.

Al Camp
 
Kenny,
I think we crossed wires on this one, and I misunderstood why you weren't
using my original solution.
Please check this out...

I replied initially with this...
This concatenation would visually yield what you asked for...
= "10mm * 10mm =" & (10 * 10) & "mm"
Click to expand...

I mistyped... and it should have read...
This concatenation would visually yield what you asked for...
= "10mm X 10mm = " & (10 * 10) & "mm"
Click to expand...

I think this is what you want. It will display as...
10mm X 10mm = 100mm

hth
Al Camp
 
Back
Top