ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   numbers (https://www.excelbanter.com/excel-discussion-misc-queries/228075-numbers.html)

Kristen

numbers
 
when i enter 1-1 it keeps going to the date I'd rather it not do that how do
i stop it?

Jacob Skaria

numbers
 
Enter this as '1-1 into a cell which will format that as text..

If this post helps click Yes
---------------
Jacob Skaria


"Kristen" wrote:

when i enter 1-1 it keeps going to the date I'd rather it not do that how do
i stop it?


Jacob Skaria

numbers
 
If you have similar information to be entered into an entire column; select
the column..Right click..Format Cells..as Text before you start entering the
data//
--
If this post helps click Yes
---------------
Jacob Skaria


"Kristen" wrote:

when i enter 1-1 it keeps going to the date I'd rather it not do that how do
i stop it?


FSt1

numbers
 
hi
perhaps you forgot to mention that you can preceed the input with an
apostrophe and accomplich the same thing.

regards
FSt1

"Jacob Skaria" wrote:

If you have similar information to be entered into an entire column; select
the column..Right click..Format Cells..as Text before you start entering the
data//
--
If this post helps click Yes
---------------
Jacob Skaria


"Kristen" wrote:

when i enter 1-1 it keeps going to the date I'd rather it not do that how do
i stop it?


Jacob Skaria

numbers
 
No dear, the initial post was about apostrophe..
--
If this post helps click Yes
---------------
Jacob Skaria


"FSt1" wrote:

hi
perhaps you forgot to mention that you can preceed the input with an
apostrophe and accomplich the same thing.

regards
FSt1

"Jacob Skaria" wrote:

If you have similar information to be entered into an entire column; select
the column..Right click..Format Cells..as Text before you start entering the
data//
--
If this post helps click Yes
---------------
Jacob Skaria


"Kristen" wrote:

when i enter 1-1 it keeps going to the date I'd rather it not do that how do
i stop it?



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

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