Dots missing

J

jiser

Hi,

I got a problem. Somehow all the dots (.) seems to be deleted from my
all sheets of a excel document. Does somebody know how to repair this

Thanks

Michael
 
S

SamuelT

Check the cell formatting (Right Click>Format Cells). It may be tha
you've set the decimal places to 0. If so, just increase it to howeve
many decimal place you want
 
J

jiser

No, that's not the problem. Because f.e 8.49 has turned into 849.00.

But also dots in text strings has been deleted somehow
 
D

Dave Peterson

Could someone have done:
Edit|replace
what: . (dot)
with: (leave blank)
replace all?

If this happened, I don't know of any way of getting back the original
values--text or numbers.
 
J

jiser

Jut happened again!!! All dots disappeared :(

The file contains almost 17 mb of data. Is MS excel xp too stupid t
handle that?
 
D

Dave Peterson

Did it happen just once or does it happen to all your workbooks?

You could have a "helpful" macro gone astray that's doing the changes for you.

If it happens in all your workbooks, try opening excel in safe mode:

close excel
windows start button|Run
excel /safe

file|open your workbook (with dots in them)

If that stops the problem, you're gonna have to find out what's going on.

Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm

=====

If it only happens in one workbook, but it didn't happen when you opened in safe
mode, it still could be a macro.
 
G

Gord Dibben

Just curious but if all the dots(.) are missing, how did 8.49 turn into 849.00


Gord Dibben Excel MVP
 
J

jiser

It can't be a maro because the problem happened suddenly. I haven't
created a macro in this document for a few months. I'll check the pages
Chip Pearson and Jan Karel. The problem only happened at one
excel-document
how did 8.49 turn into 849.00
Click to expand...
That's because the cells are formatted as financial. But the actual
amounts are transfered form 8.49 to 849
 
Top