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

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

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

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