#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 |
#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 |
All times are GMT +1. The time now is 05:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com