| 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 |
| 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) | |||
Threaded Mode
