On Thu, 4 Jan 2007 08:54:00 -0800, rossinvrland
wrote:

Hi,
I'm looking to have a function or format or macro to take a user entry into
a cell and then automatically prefix that entry and display the result. For
example, if the prefix is set to ABC & the user enters 123 in cell A1, then
as soon as the user goes to another cell, then A1 will display ABC123.
I tried CONCATENATE, but that doesn't do quite what I am looking for because
it keeps changing every time the worksheet is refreshed. There's got to be
something simple to make a function out of a simple 'find & replace' task.
Thanks in advance!
Ross

Format/Cells/Number/Custom Type: "ABC"General

For General you can substitute any valid number format.
--ron