| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
One way to try:
Select the column Click Data Text to Columns Finish -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Ronald" wrote in message ... how to change data in worksheet in text without confirming each single cell with F2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Bring all text from "Text" worksheet | Excel Discussion (Misc queries) | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
