Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Greetings,
I'm trying to make a spreadsheet of available guns at our store and I need to type in things like: ..410 ..300 ..308 ..243 30-06 but it self corrects .410 to .41 and if I write 10-11-11 it wants to create a date. How do I turn off the formatting so I can type in decimals and hyphens without excel correcting them to some other format? Thanks, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove hyphens in text | Excel Worksheet Functions | |||
Does XL2K have hard hyphens? | Excel Discussion (Misc queries) | |||
Does XL2K have "hard hyphens" (non-break hyphens)? | Excel Discussion (Misc queries) |