| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Numbers change to dates automatically
I have dot as a default date separator in regional settings (comma is a
default decimal separator). Now, if i type in a cell e.g. 2.5 it becomes a date. Is there a way to prevent this change to date? I don't want to change reginal settings. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
| automatically change text case on entry | Excel Discussion (Misc queries) | |||
| Can I change a column of dates from USA to UK format? | Excel Discussion (Misc queries) | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Threaded Mode
