ExcelBanter - How to stop excel replaceing numbers with the date?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to stop excel replaceing numbers with the date? (https://www.excelbanter.com/excel-discussion-misc-queries/4066-how-stop-excel-replaceing-numbers-date.html)

Jamescowles

How to stop excel replaceing numbers with the date?

Jason Morin

One way is to precede the entry with an apostrophe (').

HTH
Jason
Atlanta, GA

-----Original Message-----

.

Bob Phillips

If it is fractions, try preceding with 0 and then a space before the
fraction.

--
HTH

Bob Phillips

"Jamescowles" wrote in message
...

All times are GMT +1. The time now is 11:30 AM.