I don't understand =A00011220 as a formula. Is A00011220 a defined name?
--
David Biddulph

"AccessHelp" wrote in message
...
Hi,

I have a formula "=A00011220" in Cell A1; however, the result of A1 is
"A".

In Cells C1, D1 and E1, based on the formula in A1, I want them to show
"A0001", "12" and "20", respectively. The formula in A1 will be the same
format anytime.

Basically, is there a function in Excel that remove the "=" from a formula
and turn it into text or a function that turns the actual formula into
text?

Thanks.