Covertion

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

Similar Threads

Formula for ecimal place 3
when I type numbers in a cell it changes it to a decimal point 4
format entry as ###.## 2
Integers entered mysteriously divided by 100 3
Reverting formats 3
Adding a decimal point to numbers 3
Number format lost? 4
Pasting Data to Excel from either Access/Web 2

Back
Top