Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |