| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage sign
Hi
I am using the below code that I got off this forum. All works to my requirements, except, in cell L31 on all of my sheets in the workbook shows the value as a percentage, e.g. 31.16% When runing the macro, I get the value in the summary sheet as 0.311615 Q. What alteration is required to the code and where abouts it be placed to show the correct format? I am not a code writer, nor understand them and only get by with copy and paste, and therefore any help would be appriciated thanks in advance Brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200612/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show percentage data with the % sign on a bar chart? | Charts and Charting in Excel | |||
| The fx button and the "=" sign | Excel Discussion (Misc queries) | |||
| Displaying percentage in ranges in pivot table | Excel Worksheet Functions | |||
| How can I add a percentage sign to a cell with data validation | Excel Worksheet Functions | |||
| Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
