| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! return from format change
I am trying the change the formatting of cells from General to Text. I am
inserting a new column, setting it to General, then use the formula =TEXT(,AD2) and so on for the whole column. Some of those cells that contain text and numbers (e.g. VN756) come back with the result of #VALUE! others do not. I have just used Format Cells tool without success. How do I make the cells data change to be text without returning the error of #VALUE!? Thank you, Elvis |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE! return from format change
=TEXT(AD2,"@")
Are you posting from the 7-11<g Gord Dibben MS Excel MVP On Thu, 6 Dec 2007 16:17:00 -0800, Elvis wrote: I am trying the change the formatting of cells from General to Text. I am inserting a new column, setting it to General, then use the formula =TEXT(,AD2) and so on for the whole column. Some of those cells that contain text and numbers (e.g. VN756) come back with the result of #VALUE! others do not. I have just used Format Cells tool without success. How do I make the cells data change to be text without returning the error of #VALUE!? Thank you, Elvis |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
| Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Linear Mode
