View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] peshotanchowna@hotmail.com is offline
external usenet poster
 
Posts: 1
Default 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