Mar 28 2019 05:25 AM
I need help with cell formatting. I am pulling from a file that has numbers displayed as text. I am trying to format that number and then copy and paste to a Vlookup file to auto populate. My issue is that when I paste that number it displays the right format but in the formula bar it is the original format causing the V lookup not to work.
Example: 48221234 ; I custom format it to 48-22-1234. In the cell it reads 48-22-1234 but in the formula bar it still says 48221234
Mar 28 2019 06:04 AM
Number formatting does not change the number as read. For that you would need something more like
= LEFT(V, 2) & "-" & MID(V, 3, 2) & "-" & RIGHT(V, 4)
where V is the value you wish to format.
Mar 28 2019 10:24 AM