Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format as %
Hi All, What would be the syntax for format(my formula,"percent")? Help appreciated Thanks Sye -- sazi ----------------------------------------------------------------------- saziz's Profile: http://www.excelforum.com/member.php...nfo&userid=635 View this thread: http://www.excelforum.com/showthread.php?threadid=47734 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
format as %
Is your formula in a cell?
If so, <formulalocation.NumberFormat = "0.00%" replace <formulalocation with whatever syntax you want to refer to the cell (ActiveCell, Selection, Range("A1"), Cells(1,1) etc.) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
format as %
Two different choises, suppose your number is 0.15:
1. Click on the cell, pull-down Format Cell Number Percentage cell will now show as 13.00% 2. If your number is 15, click on cell, pull-down Format Cell Number Custom and enter General" %" -- Gary's Student "saziz" wrote: Hi All, What would be the syntax for format(my formula,"percent")? Help appreciated Thanks Syed -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=477349 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
format as %
? format(.2345,"#.0%")
23.4% -- Regards, Tom Ogilvy "saziz" wrote in message ... Hi All, What would be the syntax for format(my formula,"percent")? Help appreciated Thanks Syed -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=477349 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
format as %
Thank you Tom, JakeyC & the Student of Gary for help. It was in a VB code so (#.0%) helped. Thanks once again Syed (I am not even a student sofar...I guess I can be a students' student.) : -- sazi ----------------------------------------------------------------------- saziz's Profile: http://www.excelforum.com/member.php...nfo&userid=635 View this thread: http://www.excelforum.com/showthread.php?threadid=47734 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |