G
gbosch
Somehow my computer automatically converts any data with hyphens into dates!
Can anyone tell me how to remove this default?
Can anyone tell me how to remove this default?
B
Bob Phillips
You cannot remove it as that is how Excel knows it is a date, but you can
change the cell format to text, or precede it with a single apostrophe '.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
change the cell format to text, or precede it with a single apostrophe '.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
C
CLR
You can circumvent the situation by typing a leading apostrophe, or by
pre-formatting the cell for TEXT.
Vaya con Dios,
Chuck, CABGx3
pre-formatting the cell for TEXT.
Vaya con Dios,
Chuck, CABGx3
T
Turquoise_dax
Select the cells, right click and go to "format cell" menu.
Under the "number" tab, the "text" category will enable you to keep the
text as you entered it.
The default
Under the "number" tab, the "text" category will enable you to keep the
text as you entered it.
The default
T
Turquoise_dax
Sorry, hit the "submit reply button".
The default is "general", but converts those numbers to date.
That's it!
The default is "general", but converts those numbers to date.
That's it!