| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
What I have done is just make a cell be the number 1 and then do a copy(on this cell) then special paste formula and multiply on all the cells you want to convert. Not sure if 97 will work.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retain Numbers as Text Format When Importing. | Excel Discussion (Misc queries) | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Extract numbers from cell with Text and Numbers | New Users to Excel | |||
| Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Hybrid Mode
