Thanks - That Worked!
--
Rodman Veney


"Shane Devenshire" wrote:

Hi,

Just copy the number into Excel and select a column of them
1. choose Data, Text to Columns, and click Next twice
2. In the preview pane select the column with the numbers and click Text in
the top part of the window.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Rodman" wrote:

When copying a numeric text string (i.e., 1234, 5678) from Notepad into a
General formatted cell of Excel the text is reformatted as a number (i.e.,
12,345,678). Is there a formula or macro to stop this and leave the text as
a numeric string?

Thanks In Advance
--
Rodman Veney