I have a column with formatted leading zero integer values like this:
12345678910
00123456789
and I need to insert a space in this string like this:

I need a formulae that can read figures in a specific cell e.g 123 and change
them into words (One Hundred Twenty Three)

Hi, I have a large series of numbers saved in one column
[34,5,21,98,34,3,432,55,27,90,1125,......]. These data are indexed, e.g. by
[1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,......] which are in another column.
I need to calculate percentiles (25%,50% and 75%) of these numbers for

This is the formula I am using and it works good....
=SUM(IF(ISERR(FIND("-",G15:G125)),,REPLACE(G15:G125,1,FIND("-",G15:G125),"")-LEFT(G15:G125,FIND("-",G15:G125)-1)+1))
I now need to extend down to cell G133 instead of G125
I have manually changed all the G125s to G133 but then it ...

How can you disable the message upon opening a file without setting the
security to lowest? I do not want to give the user options to disable or
enable the macro.
Is that possible?

I accidently saved a spread sheet as something else and I need to get back
the previous item?

I want to use the same formula a load of times in one column, the only thing
differing being the cell number it's working on.
Kinda like adding up 2 cells on the left, and putting it in a new cell on
the right, and doing that 100 times

I have a spreadsheet with 12,000 rows of data.
Each row has data on the product and country it is sold.
The columns are basically labeled:
Product Name  Argentina Austria Brazil Belgium....and so on....

I thought if I formatted a cell as [h]:mm:ss, I would be able to enter  
57:00 into a cell
but it changes it 02/01/1900  09:00:00 (whihc is I know 2 days and 9 hours  
from base date)

I'm looking to be able to type 2 lines of text in a single cell. Each time I
press "enter" my cursor goes to the next cell. Is there a way to do this.
Next. I'm trying to create a reservation book for my restaurant. I have the
form all setup the way I like it but I was wondering ...

I have Excel 2003 and would like to print with more than 1024 characters in a
cell. Currently any characters beyond the 1024 characters are not displayed
under the 'wrap text' function.
Thank-you

Please refer to the INDEX () in Help.
(1)  Please scroll down and take a look at the third example of Reference
form.
=SUM(INDEX(A1:C11,0,3,1))

Don't know what key I clicked but when I try to add 6.36 to a cell I get
1/6/1900 in that cell instead after hitting Enter. In the formula bar above,
I guess; the value is 4.27. Just adding up expenses in a single column,
nothing tricky. Thanks, Steve T.

Hi.  Lucky me...first post on this forum but thanks in advance if you can help.
I recently performed an update.  Since today I notice all programs seem to
open without problem except for excel.  It wants me to insall excel with
frontpage before opening.  Naturally it does not open ...

I have a question which can get quite detail with the explantion unless I am
able to post the actual spreadsheets to go with the questions?