Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"You must enter a number in this cell" - ???
Many moons ago I downloaded a template for an invoice from the MS download
area. I customized it to my needs, have no idea what the orignal looked like at this point. I use it almost daily, but there is one problem with it that I have finally had enough of and can't figure out how to get rid of. In the column I have named Qty, the cell format is set to number, no decimal places, for the cells in that column. If I enter, say "484." - no problem. However, if I enter "484" (no decimal point after the digits) or "484.5" I get a pop-up that says "You must enter a number in this cell. Continue?" and the choices of yes, no, or cancel. I've been in the habit of pressing "yes" and continuing on my way, but it's really annoying to have this pop-up all the time if I forget to hit the . or want to enter something other than a whole number (484.5, for example). I have tried changing the cell format to number with 1 or 2 decimal places, but that doesn't help, the pop-up persists. How can I keep the format as "number" and get rid of this annoying pop-up? Thanks, CD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"You must enter a number in this cell" - ???
Sounds like the message is being generated by VBA code and has nothing
to do with the raw cell formatting. To see if there's VBA attached to your spreadsheet, try "Alt-F11" (or the menu system "Tools / Macros / Editor") and in the "Project" window, look for a "Modules" section. If there's anything there, that may well be the source of the message. Deleting or disabliong a message generated by VBA can be done, but there's no generic way of describing how. Less likely, given the description of the message box, is that the message is the result of data validation on the cell in question. To check that, try "Data / Validation" on the menu system and see if there's anything there. If so, you can remove it within that same dialog box. HTH / Tyla / On Feb 10, 6:29 pm, CD wrote: Many moons ago I downloaded a template for an invoice from the MS download area. I customized it to my needs, have no idea what the orignal looked like at this point. I use it almost daily, but there is one problem with it that I have finally had enough of and can't figure out how to get rid of. In the column I have named Qty, the cell format is set to number, no decimal places, for the cells in that column. If I enter, say "484." - no problem. However, if I enter "484" (no decimal point after the digits) or "484.5" I get a pop-up that says "You must enter a number in this cell. Continue?" and the choices of yes, no, or cancel. I've been in the habit of pressing "yes" and continuing on my way, but it's really annoying to have this pop-up all the time if I forget to hit the . or want to enter something other than a whole number (484.5, for example). I have tried changing the cell format to number with 1 or 2 decimal places, but that doesn't help, the pop-up persists. How can I keep the format as "number" and get rid of this annoying pop-up? Thanks, CD |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"You must enter a number in this cell" - ???
Select the cell and DataValidation.
Clear the DV for that cell. Gord Dibben MS Excel MVP On Sat, 10 Feb 2007 18:29:00 -0800, CD wrote: Many moons ago I downloaded a template for an invoice from the MS download area. I customized it to my needs, have no idea what the orignal looked like at this point. I use it almost daily, but there is one problem with it that I have finally had enough of and can't figure out how to get rid of. In the column I have named Qty, the cell format is set to number, no decimal places, for the cells in that column. If I enter, say "484." - no problem. However, if I enter "484" (no decimal point after the digits) or "484.5" I get a pop-up that says "You must enter a number in this cell. Continue?" and the choices of yes, no, or cancel. I've been in the habit of pressing "yes" and continuing on my way, but it's really annoying to have this pop-up all the time if I forget to hit the . or want to enter something other than a whole number (484.5, for example). I have tried changing the cell format to number with 1 or 2 decimal places, but that doesn't help, the pop-up persists. How can I keep the format as "number" and get rid of this annoying pop-up? Thanks, CD |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"You must enter a number in this cell" - ???
Thankyou both - it was Data-validation criteria making the pop-up.
CD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
why is it that i enter a number and when printing i get a # sign | Excel Discussion (Misc queries) | |||
how can I enter a 21 digit number in a cell & keep it from change | Excel Discussion (Misc queries) | |||
How do I enter a formula in a cell so that letters= a number i.e.. | Excel Worksheet Functions | |||
You Must Enter A Number In This Cell | Excel Discussion (Misc queries) |