Menu
I have cells formatted to put a string of less than or equal to 11 numbers into the format of #####-####-##.
How can I take the formatted value and store is as the actual cell value in another cell?
eg.
Cell A1 has value 12345678, and is formatted to display 00012-3456-78. I want cell B1 to have a cell value of 00012-3456-78.
742
Select the cells that have numbers stored as text. On the Home tab, click Paste > Paste Special. Click Multiply, and then click OK. Excel multiplies each cell by 1, and in doing so, converts the text to numbers.
Select the entire column of cells you want to convert from text to numbers, right-click, and select Copy. 4. Select the first cell in the empty column you formatted, right-click the cell and select Paste Values. You'll see all of the text formatted numbers pasted in the General number format.
Go to the cell you want to link the reference cell, right click it and select > Paste Special > Linked Picture. See screenshot: Now the format and value of cell A1 is referenced to a specified cell. And the format and value of these two cells will be synchronic as below screenshot shown.
Excel Copy Cell Formatting 1 Select a cell that has the formatting that you want to copy. 2 Click Kutools > Format Tools > Copy Cell Formatting. 3 In the Copy Cell Formatting dialog box, specify the cell attributes that you want to apply to other cells. See... 4 Then click OK, and select the range that you want to apply the formatting. See More....
Now, click on the cell where you want to copy your data and again right-click the mouse button. When you click, paste as shown in the image, everything will be copied values and formats.
Right-click on the first cell of the range that you want to copy the format to. Go to the Paste Special options and select the Formatting option which is the first icon in Other Paste Options. Alternatively, you can use the keyboard shortcut Alt, E, S, T, Enter in sequence. When you press Alt, E, S, the Paste Special dialog box opens.
If you want to copy the cell formatting to multiple cells or ranges, double-click , and move the cursor across each range that you want to format one by one. Click again to cancel the Format Painter when you are done.
Try this in B1:
=TEXT(A1, "00000-0000-00")
Hope this helps.
53
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
