MrExcel Publishing
Your One Stop for Excel Tips & Solutions

decimal format


Posted by Matt on June 19, 2001 10:13 AM

I had a text document which I put in excel, and separated using text to colums. I have a column that is 4 digits long. How do I make Excel place a decimal after the second digit?

3243 should read 32.43.


Posted by Jerid on June 19, 2001 10:21 AM

Hi Matt, you can Multiply it by .01

Jerid

Posted by Matt on June 19, 2001 10:24 AM


Is there a way to format it rather than use a formula?

Posted by Matt on June 19, 2001 10:37 AM


:

Posted by Jerid on June 19, 2001 10:40 AM

Not that I know of, you could run the follwing Macro, it will change each cells value for you.

Sub FixAmount()
Sheets("sheet1").Activate
Range("A1").Select
Do Until ActiveCell.Value = vbNullString
ActiveCell.Value = ActiveCell.Value * 0.01
ActiveCell.Offset(1, 0).Select
Loop
End Sub

Make sure to change "sheet1" to your Sheets Name and change the Range("A1") to your starting range.

I hope this helps.

Jerid

Posted by IML on June 19, 2001 11:10 AM

You could format the cells as
##"."##

or as already suggested put .01 in a cell, copy it, and paste special multiply over your column

good luck