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
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