| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automatic data conversion in Excel
When I enter or import data into Excel, 30/150 becomes 30/150, but 2/24
becomes Feb 01, 2024. How to prevent excel from interpereting the data wrong way? -- :-) |
|
#2
|
|||
|
|||
|
enter
'2/24 -- Regards, Tom Ogilvy "Dejan" wrote in message ... When I enter or import data into Excel, 30/150 becomes 30/150, but 2/24 becomes Feb 01, 2024. How to prevent excel from interpereting the data wrong way? -- :-) |
|
#3
|
|||
|
|||
|
Thank you Tom, it works for key entry.
Is it possible to prevent Excel from 'thinking' for me? Is there some setting to tell Excel NOT TO understand 1/19 as January 19, 2005? :-) "Tom Ogilvy" wrote: enter '2/24 -- Regards, Tom Ogilvy "Dejan" wrote in message ... When I enter or import data into Excel, 30/150 becomes 30/150, but 2/24 becomes Feb 01, 2024. How to prevent excel from interpereting the data wrong way? -- :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
| Linking the data from one excel to another | Excel Discussion (Misc queries) | |||
| Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
| Fan charts | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
