If your data is in A column put B2 = --(a2) or B2 = value(a2).
Copy it down.
best wishes
Sreedhar

"Gaffnr" wrote:

Hi, I am dumping data from an external system into Excel via a 3rd party
application. When a particular field comes into JDE, its come in as text.

i.e. 00350, 00390. I need these to show as numbers because they are needed
in a numerical formula. I can highlight the full range and click on the
little warning icon that pops up (when the top left of the cell is a tiny
green triangle) and use convert to number. However, I have four different
dumps all with the same issue. Its a pain in the butt to have to do this.
Is there a formula I can use?

Thanks
Rob
--
Rob Gaffney