| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you convert 100- to -100?
I have a spread sheet that instead of having -100 (negative 100), it shows
negaive 100 as 100-, is there anyway that I can convert this back to -100 faster by using a formular instead of typing it one by one, it's like 1000+ rows. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you convert 100- to -100?
DataText to ColumnsNextNextAdvanced
Make sure "Trailing minus for negative numbers" is enabled then hit Finish. Gord Dibben MS Excel MVP On Fri, 27 Mar 2009 14:28:01 -0700, How to convert from 100- to -100 <How to convert from 100- to wrote: I have a spread sheet that instead of having -100 (negative 100), it shows negaive 100 as 100-, is there anyway that I can convert this back to -100 faster by using a formular instead of typing it one by one, it's like 1000+ rows. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can the "convert" function in excel convert to UK gallons? | Excel Discussion (Misc queries) | |||
| how will i convert 05.01.2007 convert 05.Jan.2007 format? | New Users to Excel | |||
| convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Linear Mode
