Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What worksheet function will formatlessly copy cell contents?
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! |
#2
|
|||
|
|||
Hi!
I know how to stitch together my values, but the "general" formatting keeps changing my dates into an apparently unrelated number. Try this: Column A = dates Column B = numeric values Column C = alpha values (letters) =TEXT(A1,"mmddyy")&B1&C1 Biff "MargueriteL" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Function | Excel Discussion (Misc queries) | |||
copy worksheet (keeping formats) | New Users to Excel | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Need Help to Prevent Copy Function Use in a Read-Only Workbook | Excel Worksheet Functions | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |