i'm trying to insert "11-21" but it keeps changing it to 21st Nov. how do i stop it from doing tht?
B bpk May 26, 2007 #1 i'm trying to insert "11-21" but it keeps changing it to 21st Nov. how do i stop it from doing tht?
D Dave Peterson May 26, 2007 #2 You can preformat the cell as text (Format|cells|Number tab|Text) Then do the data entry or start with a leading apostrophe: '11-21
You can preformat the cell as text (Format|cells|Number tab|Text) Then do the data entry or start with a leading apostrophe: '11-21
