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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
decimal & percent format
Are you sure the .88 entries are really numbers? Expand the column to very
wide and clear all formats. If the .88 are actually text entries, they will be left justified. Robert Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Guedj54" wrote in message om... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
decimal & percent format
Yes it is left justified with a green rectangle on the top left... What should I do from there.
"Bob Flanagan" wrote: Are you sure the .88 entries are really numbers? Expand the column to very wide and clear all formats. If the .88 are actually text entries, they will be left justified. Robert Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Guedj54" wrote in message om... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
decimal & percent format
click on the green triangle and have it correct the entry.
-- Regards, Tom Ogilvy "guedj54" wrote in message ... Yes it is left justified with a green rectangle on the top left... What should I do from there. "Bob Flanagan" wrote: Are you sure the .88 entries are really numbers? Expand the column to very wide and clear all formats. If the .88 are actually text entries, they will be left justified. Robert Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Guedj54" wrote in message om... 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 |
Reply |
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 |