help with number format

kevino

New Member
Joined
Dec 13, 2005
Messages
2
can someone give me a formula for taking a text cell with a negative at the end of it and turn it into a negative number (for example turn 1234.00- into (1234.00).

thank you,

Kevin
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,118,796
Messages
5,574,359
Members
412,588
Latest member
FabrizioMaurizio
Top