ExcelBanter - How do I prevent excel from automatically changing my numbers?

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

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

- - How do I prevent excel from automatically changing my numbers? (https://www.excelbanter.com/excel-discussion-misc-queries/123026-how-do-i-prevent-excel-automatically-changing-my-numbers.html)

nick

How do I prevent excel from automatically changing my numbers?

Nick Hodge

How do I prevent excel from automatically changing my numbers?

Nick

Change them from what, to what?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk

"Nick" wrote in message
...

Max

How do I prevent excel from automatically changing my numbers?

Either preformat the col as text, or precede the entry with an apostrophe
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nick" wrote in message
...

How do I prevent excel from automatically changing my numbers?

All times are GMT +1. The time now is 07:01 PM.