Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |