| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
decimal & percent format
Hi,
I have a spreadsheet where I want column Y to be in percent format. So I put the following line in the code: .Range("Y" & lRow).NumberFormat = "0.0%" It is working fine except for some user!? For them some of the data in the column show in decimal format (ex ..88) and some in percent (ex 88%). Can it be something to do with their local setting? Thank you. Guedj54 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what tab for calculating percent and decimal? | Excel Worksheet Functions | |||
| Show decimal as percent | Excel Discussion (Misc queries) | |||
| How do I format a negative percent? | Excel Discussion (Misc queries) | |||
| Percent Format without Percent Sign | Excel Programming | |||
| Percent Format | Excel Programming | |||
Threaded Mode
