| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Mask
" wrote: The cells need to either be formatted as text before the import, or the data entered with ' before it to represent text eg '12-50 will display as 12.50 if typed in. On 16 May, 00:42, Armando wrote: This is probably a dumb question but I am having some trouble when importing data into excel. Excel seems to be taking my data and formatting it automatically. For example I have a field that asks how many users were affected. Excel will take the answer of 1-10 and interpret it as Jan-10 or data that is 12-50 and interpret it as Dec-50. Does anybody know how to stop excel from doing this? Thanks in advance and sorry about the lame question. Thanks for the response George. But the file that I have is saved as a CSV file so excel opens it automatically. This cause the cells to interpret 1-50 as Jan-50. If I then try to format the cell as text I get something like 18264. Any ideas on how to stop excel on interpreting those items as dates? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input Mask | Excel Programming | |||
| Input Mask | Excel Worksheet Functions | |||
| Input Mask | New Users to Excel | |||
| Input Mask | Excel Programming | |||
| Mask input in input boxes? | Excel Programming | |||
Threaded Mode
