Thread
:
Format - Add space between number and symbol (%)
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Format - Add space between number and symbol (%)
just try re-formatting the column(s)
selectright clickformatcustom 0.00 %
--
Don Guillett
SalesAid Software
"Alex St-Pierre" wrote in message
...
Hi !
I have a cell in Excel which contains a % (ex: 88%) and I would like to
add
a space between the number and the pourcentage. (88 %) Is there any
personalized format that allow me to add a space ?
strData = Cells(1,1 '0.88
strFormat = Cells(1,1).NumberFormat 'strFormat = 0%
if strFormat = "0%" then strFormat = ???
strData = Format(strData,strFormat)
Thank you.
--
Alex St-Pierre
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett