If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text vs. number
I was under the impression that a field should always be formatted as text
if the contents were not going to be used in calculations, so I formatted fields such as Social Security numbers and employee numbers as text. But I notice many examples in the NGs using numbers for this type of data. Should I change the formatting? Does it matter? One issue that comes to mind with formatting as text is that someone could enter a letter into the SSN field. Any other reasons? Thank you for any suggestions. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking Text Box | Richard | General Discussion | 8 | August 7th, 2004 04:47 AM |
convert text to number | Rob | Running & Setting Up Queries | 2 | June 25th, 2004 01:42 PM |
Vertical Text Orientation | Paul Anderson [MSFT] | Visio | 0 | May 11th, 2004 05:16 PM |
SUMIF mets text requirment a given number of cells to the left | Howard | Worksheet Functions | 1 | November 28th, 2003 10:58 AM |