decimal & percent format

  • Thread starter Thread starter Guedj54
  • Start date Start date
G

Guedj54

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
 
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
 
Yes it is left justified with a green rectangle on the top left... What should I do from there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to retrieve number of visible digits after decimal point in VBA 5
Excel Percents formatted for 1 decimal place 3
Numberformat applied but does not change data 11
VBA currency or percent format object 1
Show decimal as percent 3
changing format of a column in a listbox 2
Adding a decimal place 2
Changing Ribbon buttons 1

Back
Top