I am trying to remove the $- from the cells with no data on a large spread sheet

		Microsoft Office Forums > Microsoft Excel > Excel
I am trying to remove the $- from the cells with no data on a large spread sheet

FAQ

Mark Forums Read

Thread Tools

Display Modes

07-05-2018, 09:42 AM

Pecoflyer

Windows 7 64bit I am trying to remove the $- from the cells with no data on a large spread sheet

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Or
Ctrl+H
Replace what ~$- (that is tilde followed by dollar sign followed by dash)
Replace with ( leve blank)

p { margin-bottom: 0.25cm; line-height: 120%; }

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data from a specific row in a spread sheet into a form	JohnnySTI	Excel Programming	13	01-24-2018 01:20 PM
Simple Spread Sheet	TThomas	Excel	1	04-07-2016 09:01 PM
Using combobox to pass data from an Excel spread sheet to text boxes on userform	Stewie840	Word VBA	14	12-17-2015 10:13 PM
Copy data from certain Cells in new sheet	zain_shaikh	Excel Programming	1	02-11-2015 07:35 PM
Condensing a spread sheet	hawkeyefxr	Excel	4	08-22-2012 05:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:38 AM.