| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
typing in a number and converting it something else
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting a positive number to neg number in spreadsheets | Excel Discussion (Misc queries) | |||
| Typing a credit card number in a cell | Excel Discussion (Misc queries) | |||
| Converting a negative number to a positive number | Excel Discussion (Misc queries) | |||
| Can I auto fill a cell in one worksheet by typing a code number | Excel Worksheet Functions | |||
| how to get a name just by typing a number? | Excel Discussion (Misc queries) | |||
![Darrell[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
