Dots missing

[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

 

[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

 

[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

 

[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.

 

[jiser]

Jut happened again!!! All dots disappeared

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

 

[jiser]

Not that I'm aware of.... Plus, it happened to all the sheets of the
excel-document.

 

[jiser]

which is 35 sheets

 

[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.

 

[Gord Dibben]

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


Gord Dibben Excel MVP

 

[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

That's because the cells are formatted as financial. But the actual
amounts are transfered form 8.49 to 849