Format - Add space between number and symbol (%)
 

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

Format - Add space between number and symbol (%)
 

if you don't need code, you can use a custom format. just format-cells-custom
and enter 0.00 %

--


Gary


"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

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

Format - Add space between number and symbol (%)
 

When I write: 0.00%, I see, 87.59% and when I write 0.00 %, I see 0.9%. I
can't see 88 %.

Thanks!
--
Alex St-Pierre


"Gary Keramidas" wrote:

if you don't need code, you can use a custom format. just format-cells-custom
and enter 0.00 %

--


Gary


"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

Format - Add space between number and symbol (%)
 

i tried 0 % and it worked for me

--


Gary


"Alex St-Pierre" wrote in message
...
When I write: 0.00%, I see, 87.59% and when I write 0.00 %, I see 0.9%. I
can't see 88 %.

Thanks!
--
Alex St-Pierre


"Gary Keramidas" wrote:

if you don't need code, you can use a custom format. just
format-cells-custom
and enter 0.00 %

--


Gary


"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

Format - Add space between number and symbol (%)
 

It is probably because all my computer language is in french. It's strange..
--
Alex St-Pierre


"Gary Keramidas" wrote:

i tried 0 % and it worked for me

--


Gary


"Alex St-Pierre" wrote in message
...
When I write: 0.00%, I see, 87.59% and when I write 0.00 %, I see 0.9%. I
can't see 88 %.

Thanks!
--
Alex St-Pierre


"Gary Keramidas" wrote:

if you don't need code, you can use a custom format. just
format-cells-custom
and enter 0.00 %

--


Gary


"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

Format - Add space between number and symbol (%)
 

Perhaps try the following:

0.0" "%


-Ikaabod

Alex St-Pierre Wrote:
It is probably because all my computer language is in french. It's
strange..
--
Alex St-Pierre


"Gary Keramidas" wrote:

i tried 0 % and it worked for me

--


Gary


"Alex St-Pierre" wrote in
message
...
When I write: 0.00%, I see, 87.59% and when I write 0.00 %, I see
0.9%. I
can't see 88 %.

Thanks!
--
Alex St-Pierre


"Gary Keramidas" wrote:

if you don't need code, you can use a custom format. just
format-cells-custom
and enter 0.00 %

--


Gary


"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








--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=533774

Format - Add space between number and symbol (%)
 

Thanks a lot !
--
Alex St-Pierre


"Ikaabod" wrote:


Perhaps try the following:

0.0" "%


-Ikaabod

Alex St-Pierre Wrote:
It is probably because all my computer language is in french. It's
strange..
--
Alex St-Pierre


"Gary Keramidas" wrote:

i tried 0 % and it worked for me

--


Gary


"Alex St-Pierre" wrote in
message
...
When I write: 0.00%, I see, 87.59% and when I write 0.00 %, I see
0.9%. I
can't see 88 %.

Thanks!
--
Alex St-Pierre


"Gary Keramidas" wrote:

if you don't need code, you can use a custom format. just
format-cells-custom
and enter 0.00 %

--


Gary


"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








--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=533774