LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Lynx
 
Posts: n/a
Default how can i make excel stop putting numbers as dates?

i work with alot of Imperial and Metric dimensions for products, but it seems
that excel does not realy like imperial measurements. Let Us say that i ahve
a screw that is 5/8 inches long. if i put that into a cell, even formatted as
text, it will still change it to 05-Aug. same with countless other
Dimensions. I've searched high and low on how to fix this, but i cannot. I
am copieing a Large set of dimensions, and about half of them turn into
dates. any insight on how to fix this would be great.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a 3-dimensional plot in Excel? John W. Mordosky Charts and Charting in Excel 6 April 3rd 23 06:58 PM
Excel converts Mapped drive to UNC - How to stop? Fred Links and Linking in Excel 1 January 20th 05 12:24 AM
How do i increase the size of numbers in a text in Excel. Harry Cross Excel Worksheet Functions 1 November 6th 04 09:24 PM
How do I stop the autopaste function in Excel? Jules Excel Worksheet Functions 1 November 1st 04 09:54 PM
How do I stop automatic page breaks in excel Lesley Hutchinson Excel Worksheet Functions 0 October 31st 04 12:49 PM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"