Hello!
I have a database that is drawing information from several Excel spreadsheets. All of them have the same exact fields, including a cost field. The problem I am having is that in the Query I created to put them into one sheet, some of them have the value as currency, and some do not. I have double-checked the original spreadsheets, and the individual sheets show the value as currency when opened one by one.
Any ideas how I can fix this?