Steved

Posts: n/a

Replace "-" with "0"

Hello from Steved

I have a formula =Inward!B5

ok it gets the value 1-100-1
Can I please add to above formula to change the - to 0
which will give me 1010001.

Thankyou.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Search and replace	Subu	Excel Worksheet Functions	4	June 9th 05 07:01 PM
replace absolute references	bj	Excel Worksheet Functions	0	May 20th 05 07:18 PM
REPLACE outside of highlighted column	Jane	Excel Worksheet Functions	8	May 19th 05 01:54 PM
Replace Number with Text using Macro	Carter68	Excel Discussion (Misc queries)	3	April 19th 05 08:57 PM
VB Find and Replace	Bony_Pony	Excel Worksheet Functions	10	December 6th 04 05:45 PM

All times are GMT +1. The time now is 10:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us