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

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