ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   help please (https://www.excelbanter.com/excel-worksheet-functions/144227-help-please.html)

bpk

help please
 
i'm trying to insert "11-21" but it keeps changing it to 21st Nov.
how do i stop it from doing tht?

Dave Peterson

help please
 
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



bpk wrote:

i'm trying to insert "11-21" but it keeps changing it to 21st Nov.
how do i stop it from doing tht?


--

Dave Peterson


All times are GMT +1. The time now is 02:37 PM.

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