Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I stop Excel from converting a numerical entry to a date?
I'm creating a spreadsheet in which one column contains SKU (stock keeping
unit) numbers. Excel sometimes sees these values as dates and automatically converts them in my spreadsheet. For example, Excel sees 10-1999 as Oct-99. |
#2
|
|||
|
|||
How do I stop Excel from converting a numerical entry to a date?
Enter it as '10-1999. The apostrophe will convert your entry to text but
will not show in the cell. You will be able to see it in the formula bar. Alternately format the cell as text before entering the SKU. Hope this helps Rowan havanakids wrote: I'm creating a spreadsheet in which one column contains SKU (stock keeping unit) numbers. Excel sometimes sees these values as dates and automatically converts them in my spreadsheet. For example, Excel sees 10-1999 as Oct-99. |
#3
|
|||
|
|||
How do I stop Excel from converting a numerical entry to a dat
Your answer was right on target! Preceeding the numerical value with an
apostrophe forced Excel to leave the value alone. Many thanks for your help. I was ready to quit! "Rowan Drummond" wrote: Enter it as '10-1999. The apostrophe will convert your entry to text but will not show in the cell. You will be able to see it in the formula bar. Alternately format the cell as text before entering the SKU. Hope this helps Rowan havanakids wrote: I'm creating a spreadsheet in which one column contains SKU (stock keeping unit) numbers. Excel sometimes sees these values as dates and automatically converts them in my spreadsheet. For example, Excel sees 10-1999 as Oct-99. |
#4
|
|||
|
|||
How do I stop Excel from converting a numerical entry to a dat
You're welcome.
havanakids wrote: Your answer was right on target! Preceeding the numerical value with an apostrophe forced Excel to leave the value alone. Many thanks for your help. I was ready to quit! |
#5
|
|||
|
|||
How do I stop Excel from converting a numerical entry to a date?
If your stock numbers always have the same format xx-xxxx like your example, then creating a ##-#### format is a better way to solve your problem. Set that format to the whole column. That way when the user enters 102005, Excel will format it in 10-2005. Saves you two key strokes (' and -) for each entry :) Alain -- mcs51mc ------------------------------------------------------------------------ mcs51mc's Profile: http://www.excelforum.com/member.php...o&userid=28645 View this thread: http://www.excelforum.com/showthread...hreadid=483389 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can stop excel from converting value to date? | New Users to Excel | |||
format date in excel | Excel Discussion (Misc queries) | |||
How do I stop Excel from changing numbers into a date? | Excel Discussion (Misc queries) | |||
Excel file modification date | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |