Formula problem
Thank you that solved my problem.
"Gord Dibben" wrote:
Jennifer
ToolsOptionsCalculation.
Check "Automatic".
Gord Dibben MS Excel MVP
On Mon, 10 Jul 2006 12:17:02 -0700, Jennnifer
wrote:
When selecting formula =proper(cell) for a list of text the results return
the first line only and the following lines have the same result as the first
line.
For example:
HONG KONG =proper(cell 1) results: Hong Kong
CHINA =proper(cell 2) results: Hong Kong
INDIA =proper(cell 3) results: Hong Kong
EUROPE =proper(cell 4) results: Hong Kong
|