| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I stop from converting numbers (e.g 3-30) into dates
I'm trying to enter records into a spreadsheet. everytime i Try to use a
dash, it converts into a date |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I stop from converting numbers (e.g 3-30) into dates
Either pre-format the input column as text (via FormatCells)
Or precede the data entry with an apostrophe -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Proft" wrote: I'm trying to enter records into a spreadsheet. everytime i Try to use a dash, it converts into a date |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Help Converting Numbers to Dates | Excel Worksheet Functions | |||
| Converting Day Numbers to Dates... | Excel Worksheet Functions | |||
| How do I stop auto converting Text(Inventory#) to Dates | Excel Discussion (Misc queries) | |||
| Stop numbers converting to dates. | Excel Worksheet Functions | |||
| converting dates into numbers | Excel Discussion (Misc queries) | |||
Linear Mode
