Fraction

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Fractions are listed in column B and I would like them to be expressed in
numbers (2 decimals) in Column A by using VBA. Could someone please help

Thanks
 
Are the cells presently strings or jsut formated as fractions?

Highligt one of the cell and go to Format Menu - Cells - Number. If
Fractions are selected than change the formatging to numbers and set the
number to 2.

If the cells are strings then you have to remove the single quote in fron of
the number. If you copy these cells and paste special values the text will
get changed to numbers. Make sure yo paste into a diffferent cell then the
one originally copied.
 
You must log in or register to reply here.

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

Cant seem to get this to work 1
Fractions in a userform. 2
fraction udf 3
Prevent changing a fraction 2
combobox fraction 2
Convert Decimal fractions to binary and vice versa 1
Formatting text 3
Excel Excel and Fractions 3

Back
Top