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?
|