LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default minus sign

when importing a file from bus obs i get a column of data where the minus
sign for negative numbers only comes after the last character,( 435-) can
anyone supply me with a function to move the minus sign to the beginning
(-435).

Thanks once again everyone.
--
delmac
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Minus Sign JLMcCabes Excel Discussion (Misc queries) 1 March 30th 11 01:34 PM
I do not want the minus sign Steved Excel Worksheet Functions 5 December 8th 08 09:26 PM
minus sign tom mcdonald Excel Worksheet Functions 1 April 19th 06 09:58 AM
plus and minus sign in cells ivoryhunter Excel Worksheet Functions 3 April 10th 06 01:28 PM
I want to display the minus sign ED New Users to Excel 7 October 27th 05 10:06 PM


All times are GMT +1. The time now is 06:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"