Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there a way to change the input so that one does not have to prefix
a number by first entering the = or +-. I want to default it to always see it as a number unless a specify it to be text. Thanks carlob1 |
#2
![]() |
|||
|
|||
![]()
Hi
You don't need to prefix with a + or a =. Just type the number. -- Andy. wrote in message ups.com... Is there a way to change the input so that one does not have to prefix a number by first entering the = or +-. I want to default it to always see it as a number unless a specify it to be text. Thanks carlob1 |
#3
![]() |
|||
|
|||
![]()
You don't need a +, that is a Lotus throwback. You only need an - for
negative numbers. -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ups.com... Is there a way to change the input so that one does not have to prefix a number by first entering the = or +-. I want to default it to always see it as a number unless a specify it to be text. Thanks carlob1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Entering a Number | Excel Discussion (Misc queries) | |||
Random Number Questions | Excel Worksheet Functions | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |