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

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,943

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 »

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 09:09 PM.