get rid of scientific notation

I have a column of data for which I want to keep 2 significant digits. This is what a few rows of data look like:

0.0000041
0.00000033
0.00000044
0.0000043
0.00000040

I would like to copy and paste this data from Excel to Word, however, when I do this, the data (or some of the data) are automatically converted to scientific format, which I DO NOT want. I have tried changing the cell format in Excel from number/general to text, however, when I do this, the data (again) is automatically converted to scientific format. I want the data to look exactly like it does above once it is pasted into Word.

This is extremely FRUSTRATING! I have a lot of data to work with and need help!

Thanks

Hey there,

I changed the cell's formatting to text. I then hit f2 to edit the cell and hit enter. The cell then showed the correct value and was copied correctly. This may not be helpful if you have 000s of rows.

Later,

Chris

If you change the formatting on a ton of cells and need to change them en masse you can use the following to change them all:

Select the cells you want to change (if you have formulas within the selection and want to retain the formulas, do not continue - the formulas will be removed)
Press Alt+F11 (brings up the VBA editor)
Press Ctrl+G (Launches the Immediate window)
Past the following into the immediate window

Selection.Value = Selection.Value

Press enter

You could also create a macro and assign it to a button.