Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change fromat from number to text
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change fromat from number to text
Copy the whole sheet to the clipboard (by pressing ctrl+c twice),
format all cells as text and then paste back from clipboard (by clicking on item to paste). trying to delete locking file .ldb wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change fromat from number to text
Hi Lori,
I tried your suggestion and I'm still getting the error message "The number in this cell is formatted as Text or is preceded an apostrophe". Does this mean that the data is considered a number even though the format says text? I don't understand why nothing is working. Nanette "Lori" wrote: Copy the whole sheet to the clipboard (by pressing ctrl+c twice), format all cells as text and then paste back from clipboard (by clicking on item to paste). trying to delete locking file .ldb wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change fromat from number to text
Hi Lori,
I have imported the Excel spreadsheet into Access with success. Apparently the error didn't have as much weight on the import as I thought. Still wonder why I get the message when the data is clean though. Thanks for all you help. Nanette "trying to delete locking file .ldb" wrote: Hi Lori, I tried your suggestion and I'm still getting the error message "The number in this cell is formatted as Text or is preceded an apostrophe". Does this mean that the data is considered a number even though the format says text? I don't understand why nothing is working. Nanette "Lori" wrote: Copy the whole sheet to the clipboard (by pressing ctrl+c twice), format all cells as text and then paste back from clipboard (by clicking on item to paste). trying to delete locking file .ldb wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from a Cell to a text box. | Excel Worksheet Functions | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
Change number to text formula | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions |