Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]() "N Harkawat" wrote in message ... Simply import it as it is Then do the following type 100 into a blank cell copy it select the column that hold the numbers that you need divided by 100 edit-paste special- select divide hit ok 'This will divide the entire range by 100 This should work OK if you only have to do so ocassionally. What you really should ask is if you can make the exporting program create a file with the values you want. /Fredrik |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting copied data to numbers in excel xp | New Users to Excel | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) |