Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I download a .csv sheet daily, open & save as excel, and link to access.
However, access returns some #Num errors. I need to convert several of the columns to text, from what I read by adding apostrophe. Is there a macro that I can run on certain columns that will add an apostrophe in front of all? There are 7000 lines, so doing it manually is not possible. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding info in the row at the bottom using macro? | Excel Discussion (Misc queries) | |||
Adding an apostrophe | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
macro - adding rows to a column that is summed | Excel Discussion (Misc queries) |