ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   number entering (https://www.excelbanter.com/excel-discussion-misc-queries/25124-number-entering.html)

[email protected]

number entering
 
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



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




Bob Phillips

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





All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com