Weird Characters in Excel - Profile Related - Help!!! - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Closed Thread
Thread Tools Display Modes
Old 02-02-2005, 09:56 AM   #1 (permalink)
Newb Techie
Join Date: Feb 2005
Posts: 4
Default Weird Characters in Excel - Profile Related - Help!!!

I have to keep rebuilding - my XP/2000.NEt Profile due to the fact that all of a sudden my Excel decimals in the numbers (Currency, Accounting formats) start showing up with diamonds, plus characters, etc. in lace of the decimals -even shows up in the Calculator!!! - so it is not just associated with Office. When I rebuild the profile it goes away - when I log on as another test user it is fine log back to my right profile it is hosed still - can't find in the profile what is hosing up. It happens under XP Pro SP2 plus - Any help would be appreciated - getting old rebuilding my profile - it just hoses up all of a sudden!

Thanks for any thoughts or ideas.
May God bless!

AVBunyan is offline  
Old 02-02-2005, 07:15 PM   #2 (permalink)
Wizard Techie
Join Date: Jan 2005
Location: Delaware
Posts: 3,475

Did you write it in a newer version of Excel.
This will happen if you open a new file in an older microsoft program.

turtile is offline  
Old 02-03-2005, 06:05 AM   #3 (permalink)
Newb Techie
Join Date: Feb 2005
Posts: 4
Default Weird

Thanks turtile for the response - it is possible - the original spreadsheet started out in 2000 a long time ago and has evolved to what it is now in 2003 - it is my financials - Should I just start from scratch in a fresh 2003!?!?! Sounds like I should try it - will be some work but sounds logical - may have taken a while to corrupt and now starting to show up - thanks

Just thought of something - this issue shows up even if I open up a brand new worksheet - the decimals are still whacked , but only under the current profile I am using - a penny for your thougths

God bless
AVBunyan is offline  
Old 02-04-2005, 06:34 PM   #4 (permalink)
S e c u r e d
Join Date: Feb 2005
Location: Somewhere Sunny
Posts: 3,760

try to remove the application data folder from your local profile...

c:\Documents and Settings\(your name here)...
make sure you have the hidden files and folders showing.
remove folder, or atleast the excel folder from the microsoft folder.
brady is offline  
Old 02-04-2005, 07:04 PM   #5 (permalink)
Newb Techie
Join Date: Feb 2005
Posts: 4
Default Good suggestion

Thanks "brady" for your response - Good suggestion - I did try that already since it was profile reelated, so we are thinkin alike - but what that does is reset the Excel worksheet template - remember this weird decimal point shows up in calculator also!!!!!!!!!!! Gasp

Thanks again - I'm open for any other suggetsions

May God bless
AVBunyan is offline  
Old 02-05-2005, 07:21 PM   #6 (permalink)
Newb Techie
Join Date: Feb 2005
Posts: 4
Default Figured it out

If anyone is interested - I went into Control Panel- Regional and Language Settings-Customize under English - found the decimal point was corrupted - switched it back to the period and it fixed it - Amazing!!!!

God bless

AVBunyan is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

» More about our Communities

Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities

Copyright 2002-2015 Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 12:39 PM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.