Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing Text
I've got an Excel template that users enter data into. We have Customer ID's
with leading zeros, but Excel cuts them off and treats them as numeric values. Is there any way I can define a column as text so the user can enter 0000456 without having to key a ' before the entry? I've tried defining the column using Data = Text to Columns = Text, but that isn't working. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion to Text file format error | Excel Discussion (Misc queries) | |||
How do I copy text from one workbook to another | Excel Discussion (Misc queries) | |||
Shade cell according to text? | Excel Discussion (Misc queries) | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |