| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert function, please help
Hi,
I have an input from a data file, the field value for example is 2300000. I need a string function to insert a decimal point before the second last 0. Hence the number should be 23000.00. Can anyone please advise. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
insert function, please help
Hi, Based on the assumption that the data to change is in cell A1 here are a couple of options: * type "=A1/100" into cell B1 (without the appostrophes), format the cell to show 2 decimal places if wanted, & copy down for as many rows as required. * type 100 into an empty cell, select it, press [ctrl +c], select the range of cells you wanted changed, press [alt + e + s + i] & then [enter]. hth Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=544057 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert function | Excel Discussion (Misc queries) | |||
| Insert function | Excel Programming | |||
| Insert function - custom function name preceded by module name | Excel Programming | |||
| insert row within function | Excel Worksheet Functions | |||
| How do I insert a row when using an if function | Excel Worksheet Functions | |||
Linear Mode
