"the cell currently being evaluated contains a constant"

M

MP

I getting this message trying to use the "DateValue()" function it is giving
me this error. I have checked the formatting it is general I made sure that
there was no space before the = sign. Can someone help with this error?
 
P

Pecoflyer

MP;223139 said:
I getting this message trying to use the "DateValue()" function it i
giving
me this error. I have checked the formatting it is general I made sur
that
there was no space before the = sign. Can someone help with thi
error?
Click to expand...

Is your cell formatted as text ?
Format as general put the cursor in the formula bar and press "enter

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 

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

The cell currently being evaluated contains a constant 1
cell currently being evaluated contains a constant 2
Data Validation "The Source Currently Contains an Error" 0
Calculate the median value before a specified list 0
How do I fix: cell won't calculate because it is a constant? 1
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
Microsoft Excel 1
Find text in cell and copy from 4 characters in front of the found text. 2

Top