formating problem

swaink

Active Member
Joined
Feb 15, 2002
Messages
432
Hi Everyone

Wonder if you can help please..

I have a file that has been extracted and sent to me but I have one column in which the cells are showing as for example 3.69998E+11 where as it should show as 369998159740..

I have tried formating the column as text but I then need to enter each cell individually using F2 then enter to make the change.

Obviously this is this is very time consuming with several thousand rows.

I have tried pasting the values again and used the ADD option but this did not solvle the problem either.

I have written a macro to step through each cell until the end of the column but is there a way to select the cell as if editing then enter again to activate the change.

Any advise would be appreciated

Regards

Kevin
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,393
Office Version
  1. 365
Platform
  1. Windows
Highlight your column, select Data | Text to Columns, go to Step 3 and select the Text option and click Finish.

This will convert all your entries to text and it will look like you want.
 

swaink

Active Member
Joined
Feb 15, 2002
Messages
432
Hi jmiskey

Absolutely excellent thats done the job in double quick time

Many thanks for your time I appreciate your help

Rgds

Kevin
 

Watch MrExcel Video

Forum statistics

Threads
1,118,285
Messages
5,571,310
Members
412,381
Latest member
RogerL
Top