Thread: How do I stop from converting numbers (e.g 3-30) into dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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 With QuoteReply With Quote