What worksheet function will formatlessly copy cell contents?

M

MargueriteL

hi!

I'm trying to get MS Excel to autocreate my serial numbers. This requires
doing one of the following:
a. a formula entry that will (regardless of formatting) give me EXACTLY what
is in the reference cell (unlike the CELL function, which reformats the
reference); or
b. some sort of formatting/function call that would take date (mmddyy)
values from one column, numerical values from another column, and letters
from a third.

I know how to stitch together my values, but the "general" formatting keeps
changing my dates into an apparently unrelated number.

Thanks!
 
B

Biff

Hi!
I know how to stitch together my values, but the "general" formatting keeps
changing my dates into an apparently unrelated number.
Click to expand...

Try this:

Column A = dates
Column B = numeric values
Column C = alpha values (letters)

=TEXT(A1,"mmddyy")&B1&C1

Biff
 
Top