I'm running Excel 2003; trying to insert in a cell a "phone" symbol which I've inserted via above Char code.
However in cell it only appears when I double click cell; is there a workround for this please.?
I'm running Excel 2003; trying to insert in a cell a "phone" symbol which I've inserted via above Char code.
However in cell it only appears when I double click cell; is there a workround for this please.?
Thames Valley tapper
Hi,
When you click on the cell you see '.
So what you need to do is add a second one so you now display ''.
The first one excel is seeing as text.
VBA Noob
Or you enter this formula
=REPT("'",1)
VBA Noob
Many thanks
Many Thanks!!
![]()
code 39 barcode encoder add-in for excel, please have a look!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks