Custom Format as "S"0.00

Leave off the .00 if you just want whole numbers.

The cell value will still be 12345 but display as S12345

Gord Dibben Excel MVP

On Mon, 27 Dec 2004 10:25:09 -0800, Kendosan1
wrote:

How can I prepend the contstant string "S" to each numeric value entered into
the cells in a column? For example, if a user enters "12345" into a cell, I
want the cell value to be "S12345".