numbers to text with correct charcter placement

I have a column of decimal numbers. I need them to be string text. In addition though, they need to be formatted correctly.

Currently the numbers have a 0 in front of the decimal. The numbers can range from 0.0001 to 0.9999.

Some of the numbers are like this: 0.03, 0.001, 0.0005, 0.5.

I need to get rid of the decimal place, but have a four character string.

So 0.0001 should result in '0001'
and 0.03 should result in '0300'

I used to do this stuff all the time but it has been WAY to long.

Any help would be appreciated.

...Excel 2003

Hi ftjjk,

Here's a macro that will do the job - just change the references in the code to suit (I've made a note where to do this):

Please Login or Register  to view this content.

HTH

Robert

Hi

A formula approach

=TEXT(A1*1000,"0000")

Then copy pastevalues from the formula output over the original data.


rylo