| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2003 - converting 51322 to 513.22
divide by 100.
"tuzdazchild" wrote in message ... need assistance in converting three columns of numbers (all 5digit) to insert the decimal 2 places in. I am only able to add decimal at end, which makes it 51322.00 only other way is to manually change each cell, and that's about 3000 cells! please advise, and thanks, in advance for prompt reply. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONVERTING OFFICE 97-2003 EXCEL FILES TO 2007 EXCEL | Excel Discussion (Misc queries) | |||
| Converting Excel 97 files to 2003 | Excel Discussion (Misc queries) | |||
| converting office excel 2007 to excel 2003 | New Users to Excel | |||
| converting international characters in English in Excel 2003 | Excel Discussion (Misc queries) | |||
| Converting Works 2001 Spreadsheet to Excel 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
