Importing data

More
7 years 2 months ago #5752 by Morris
Importing data was created by Morris
I have imported an excel file and the numbers have turned into hashtags. This doesn't normally happen and I can't figure out why it has done this. I have imported files before and the numbers have appeared. Please help!

Please Log in or Create an account to join the conversation.

More
7 years 2 months ago #5753 by bert
Replied by bert on topic Importing data
Hello Morris,
That may happen if the numbers you had in that Excel file were the result of calculations or other specific Excel configurations.
Since iDoceo won't calculate the same way as Excel does, you may see hashtags or it may be left empty.
Open that Excel file in Numbers or Excel and save it as CSV instead before 'Opening in' iDoceo. This will consolidate the results and you should be able to import it as expected.
The following user(s) said Thank You: Morris

Please Log in or Create an account to join the conversation.

More
7 years 2 months ago #5754 by Morris
Replied by Morris on topic Importing data
It has worked! Thank you so much!

Please Log in or Create an account to join the conversation.