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! |
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! |
All times are GMT +1. The time now is 05:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com