typing in a number and converting it something else
If that would work that would be great, however I do not
know anything about event macros.
Darrell
-----Original Message-----
you really can't do that type of math just using a
format.
Also, entering 15mm will make this a string and very
little can be done with
formatting to affect a string.
Do you want an event macro that will make the change?
--
Regards,
Tom Ogilvy
"Darrell" wrote in message
...
I am tring to make a form that I will be able to enter
in
a number and the formula will do the math. I also want
it to out put a negitive or positive number. example:
i
enter in the number 15mm into the cell and it out puts
X0001.693 So this is what I have so far in the
customize
cell featu =25.4/X0000.000;X-0000.000 Can someone
please help.
Thanks in advanced,
Darrell
.
|