T
trying to delete locking file .ldb
I have been trying to change the format of several cells from number to text
without success. I've tried the "Three ways to convert numbers to text" found
in MS's Help files, (format, cells, number, text/Text Function/Convert Text
to Columns Wizard) and they are not working. Plus, I've been getting an error
message about the numbers being defined as text and/or there are apostraphies
in the data. (The error message is sort of like the previous sentence.) There
are no apsotraphies. The data in the spreadsheet was imported from SAP.
I need to clean up the cells so that I can have the format clean for export
to Access.
Anyone have any suggestions?
without success. I've tried the "Three ways to convert numbers to text" found
in MS's Help files, (format, cells, number, text/Text Function/Convert Text
to Columns Wizard) and they are not working. Plus, I've been getting an error
message about the numbers being defined as text and/or there are apostraphies
in the data. (The error message is sort of like the previous sentence.) There
are no apsotraphies. The data in the spreadsheet was imported from SAP.
I need to clean up the cells so that I can have the format clean for export
to Access.
Anyone have any suggestions?