Covertion

G

Guest

I need to know if there is a way to conver t a cell value from 123456 to
1234.56. This value is a nuber not text.
 
J

JulieD

Hi

type .01 in an unused cell and copy it
select the numbers you want to change and choose
edit / paste special / multiply
and click the Ok button.

if you want to be able to enter 123456 into a cell and have it change
automatically to 1234.56 choose tools / options / edit / fixed decimal
places and set it to 2.

However, this will affect all numbers entered in any workbook in excel.

Cheers
julieD
 

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

Top