Forum Discussion
Cell Formatting
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 i...
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.
... or
= TEXT( V, "00-00-0000" )