How do I get a value instead of an error or txt in an Excel cell?

G

Gord Dibben

Post some samples of the data you're working with and show before and after
examples.


Gord Dibben MS Excel MVP

On Sat, 22 Aug 2009 19:25:01 -0700, Frazzled Rob <Frazzled
 
R

Rodrjua

Hi I am trying to figure out a formula that allow me to avoid sign
carachters such "#< $ % &" being enter as data what can I do? Help me!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Excel does not accept text format! 0
Use TODAY() function as the criteria in a SUMIF formula 1
Summing totals in columns where some cells have error values 1
Calculate the median value before a specified list 0
Unwanted Series Values on Line Graph 2
Chart 2
Merging from an Excel file with graphics 1

Top