Prev: Converting a non recognizable date time
Next: "Do you want to update" msg
From: igbert on 27 May 2010 16:43
I have data imported from another file to Excel with negtive numbers show as
478.56- and so on.

Is there a macro to covert all these numbers to a format (478.56)?

Thanks

Igbert
From: Jacob Skaria on 27 May 2010 17:09
You dont need a macro.

--Select the columns with numbers. From menu Data>Text to Columns>Next>Next>
--From Step 3 of the wizard click 'Advanced'
--Make sure 'Trailing minus for negative numbers' is checked
--Click OK>Finish...


--
Jacob (MVP - Excel)


"igbert" wrote:

> I have data imported from another file to Excel with negtive numbers show as
> 478.56- and so on.
>
> Is there a macro to covert all these numbers to a format (478.56)?
>
> Thanks
>
> Igbert
 | 
Pages: 1
Prev: Converting a non recognizable date time
Next: "Do you want to update" msg