I am trying to upload excel data to a databse which only accepts general values. Some one tried to help me with formulas as per attached word document but it is not working. I get #value as result. (cell colored red)
need to Import this Excel sheet into an AMS Database system - All Cells NEED "general" value even if its numbers.
Tried doing manually but main sheet has 3500 entries...:-(
I am sure there has to be easier way to do this.
Your help is higly appreciated
Thanks much
vikkam confused:
Bookmarks