tag:blogger.com,1999:blog-26496923.post5991726516812289635..comments2024-03-25T07:29:54.384-07:00Comments on CHRISdotTODD: Referencing the value of a cell, not its formulaChris Toddhttp://www.blogger.com/profile/09035433827373014702noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-26496923.post-67908507961768169552009-10-30T10:00:17.185-07:002009-10-30T10:00:17.185-07:00I used the wrong text format of #. Try using "...I used the wrong text format of #. Try using "text". For example, =TEXT(CLEAN(C2),"text")CHRISdotTODDhttps://www.blogger.com/profile/01891237750055202017noreply@blogger.com