Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add symbol to number & still act as number in excel? | Excel Discussion (Misc queries) | |||
Symbol or text after number to used in sum | Excel Worksheet Functions | |||
Format number to display % symbol smaller than onther text in cell | Excel Discussion (Misc queries) | |||
How do I create a custom number format in Excel using a symbol? | Excel Discussion (Misc queries) | |||
How do i add the squared symbol to a number | Excel Discussion (Misc queries) |