B
bailbust63
how do i stop it from changing my hyphen to forward slashes?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Are you entering stuff that looks like a date?
And you want to keep excel from helping you out by changing it to a date?
If yes,
you can preformat the cell as text (format|cells|number tab)
or
start your entry with an apostrophe: '1-3
And you want to keep excel from helping you out by changing it to a date?
If yes,
you can preformat the cell as text (format|cells|number tab)
or
start your entry with an apostrophe: '1-3
G
Gord Dibben
"It" I assume is Excel.
Are you entering Dates like 2-12-2006 which Excel changes to 2/12/2006?
Windows Regional Settings and Languages governs how dates are entered.
Change your "short date" to use hyphens.
Gord Dibben MS Excel MVP
Are you entering Dates like 2-12-2006 which Excel changes to 2/12/2006?
Windows Regional Settings and Languages governs how dates are entered.
Change your "short date" to use hyphens.
Gord Dibben MS Excel MVP
G
Gord Dibben
Then again maybe you're not entering dates but trying to enter data like
12-06 which Excel interprets as a date.
Preface with an apostrophe so Excel knows it is to be text.
OR pre-format the cell(s) as Text.
Gord
12-06 which Excel interprets as a date.
Preface with an apostrophe so Excel knows it is to be text.
OR pre-format the cell(s) as Text.
Gord