Hello,
I'm trying to figure out a way to make my formula add "" to a number automatically.
Example:
If I had a 4 in Cell A1 how could I make that = "4" in B1
Thanks,
Rob
Hello,
I'm trying to figure out a way to make my formula add "" to a number automatically.
Example:
If I had a 4 in Cell A1 how could I make that = "4" in B1
Thanks,
Rob
Last edited by RobP614; 07-10-2009 at 05:51 PM.
=char(34) & A1 & char(34)
or
="""" & A1 & """"
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks