1
  • my data in A1 cell is ABCDE. I want to display it as 56789 in B1 cell

    example: my data in A1 cell is ABCDE. I want to display it as 56789 in B1 cell. (because my codes are A=5, B=6, C=7, D=8 and E=9) In a similar way I want a formulae that automatically converts my alphabet codes in row A into number format in row B. Another similar example: my data in A2 cell is...

    umgy22335 pointsBadges:
  • Using Access query data in Excel

    I have a need to use some employee data that is contained in an Access database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any success. I can move the entire file, but I really need to move only the data that meets some selection...

    Ronmcnaughton5 pointsBadges:
  • Can ACCESS forms be used in EXCEL?

    Can forms created in ACCESS be used in EXCEL (via VBA)

    Jgenterprises10 pointsBadges:
  • Excel Transfer from iSeries ERROR

    Hi. I have created a query on the iSeries machine and then stored the results in a database file (pf). I then try to transfer the file to excel using the iAccess plugin. However I get the following error: CWBDB0052 - Error during data conversion. Any help would be greatly appreciated. Thanks

    As400novice165 pointsBadges:
  • Export from Access to Excel shifts decimal position randomly

    I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one...

    MBachman5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following