insert function, please help

[peshotanchowna]

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

 

[broro183]

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...