Thread: Converting an invalid negative number to recognizable format?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Converting an invalid negative number to recognizable format?
DataText to ColumnsNextNextAdvanced.

Make sure "Trailing minus etc." is checkemarked.


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 14:31:00 -0700, Leighanne0213
wrote:

An excalibur report printed into an excel table displays its negative numbers
with the negative sign at the end of the number. How can I move all of the
incorrect negative signs to the front of the number without having to move
them all individually?

Reply With QuoteReply With Quote