| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to stop excel replaceing numbers with the date?
|
|
#2
|
|||
|
|||
|
One way is to precede the entry with an apostrophe (').
HTH Jason Atlanta, GA -----Original Message----- . |
|
#3
|
|||
|
|||
|
If it is fractions, try preceding with 0 and then a space before the
fraction. -- HTH Bob Phillips "Jamescowles" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I stop excel replacing numerical values with the date? | Excel Discussion (Misc queries) | |||
| How do I stop Excel from changing simple numbers to their 1/100th. | Excel Discussion (Misc queries) | |||
| How can I stop Excel from displaying rounded numbers? Credit car. | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Hybrid Mode
