I'm doing up a database. My database is such that every cell would have a unique number and no repetition would occur. However when i manually typed in to excel, i save it, the next day i open, i found that excel change some of my numbers such that it matches some other cells which is not suppose to happen!
And when I do my keying in, I always double check to make sure that I don't have typo error. Why is this so? How to prevent it from happening?
Many thanks!
eh???
ur file large anot? Did u use any formula or links?
Try pressing CTRL+~ and go thru ur cells to check if everything is okay...
my file is pretty large =x
Nvr use formula or links leh. I googled, but most of the problem I see is cos their figure is 16 digits. But mine is only 5 digits and I straight away key in, nvr cnp from elsewhere or what leh. =(
might u be able to upload somewhere to share?
sorry, this one my company info, so can't upload to share share =(
I alr manually correct them. Thank cute acid. =)