Solved Excel 2007 (MS Office 2007 enterprise)

subyroo

New member
Power User
VIP
Local time
7:08 PM
Messages
107
Location
Sunshine Coast - Australia
I recently formatted my HD and reinstalled MS Office Enterprise 2007, I last used MS Excel on the 08/06/2014 without a problem, today I go to use my Excel spreadsheet and for some weird reason it wants to roundup my cells.
I have cleared the cells formatted the number but it still keeps on rounding up 25799 to 258. I downloaded a stack of MS Office updates 3 days ago, is it possible one of these Updates has corrupted - broken my Excel program?

I am considering uninstalling all of those updates and turning off Updates for MS Office altogether. :mad:
 

My Computer My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Homebuild
OS
Windows 7 Ultimate 64 bit SP1
CPU
DualCore Intel Pentium D 820, 2800 MHz (14 x 200)
Motherboard
Gigabyte EX58-UD3R
Memory
Kingston DDR3 (PC3-10700H) 6.0GB
Graphics Card(s)
AMD Radeon HD 6450
Sound Card
Realtek ALC882/D/M
Monitor(s) Displays
Samsung SyncMaster 2233SW
Screen Resolution
1920 x 1080
Hard Drives
Drive #1 - WDC WD2500JB-22REA0 (232 GB)
Drive #2 - WDC WD6400AAKS-65A7B0 (596 GB)
PSU
EVGA Supernova 750w G2 Gold
Cooling
5 x 80mm Generic Fans
Keyboard
Microsoft Comfort Curve 2000
Mouse
SteelSeries IKARI 62001-1 Laser or Microsoft Laser 6000
Internet Speed
1500/256
Antivirus
NOD32 v10.1.235.0
Browser
FireFox 59.0.2 X64bit
Other Info
Telstra Technicolor TG799vac Modem
LG HL-DT-ST DVDRAM GH20NS15 ATA Device
16X52X32X52 COMBO SCSI CDRom Device
Logitech Wave Keyboard
Microsoft 6000 Laser Mouse
Hi there.

To test if it's really a software issue, please try out on a new excel spreadsheet and see if the problem is still there. It might not necessarily be the software. Once we have confirmation that the problem exist on a fresh new spreadsheet, then try to do a repair first before uninstalling.
 

My Computer My Computer

Computer type
Laptop
Computer Manufacturer/Model Number
Lenovo E450
OS
Windows 10 Pro
Hi there.

To test if it's really a software issue, please try out on a new excel spreadsheet and see if the problem is still there. It might not necessarily be the software. Once we have confirmation that the problem exist on a fresh new spreadsheet, then try to do a repair first before uninstalling.

Opened a NEW spreadsheet and when I enter the number 25799 which what I want the cell to read it comes up as 257.99 as soon as you click enter or move to another cell.
Formatting the Cell with Number and no decimal point the number is rounded up to 258. :mad:

I am not up to speed on Excel so how do I go about repairing the software? :o
 

My Computer My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Homebuild
OS
Windows 7 Ultimate 64 bit SP1
CPU
DualCore Intel Pentium D 820, 2800 MHz (14 x 200)
Motherboard
Gigabyte EX58-UD3R
Memory
Kingston DDR3 (PC3-10700H) 6.0GB
Graphics Card(s)
AMD Radeon HD 6450
Sound Card
Realtek ALC882/D/M
Monitor(s) Displays
Samsung SyncMaster 2233SW
Screen Resolution
1920 x 1080
Hard Drives
Drive #1 - WDC WD2500JB-22REA0 (232 GB)
Drive #2 - WDC WD6400AAKS-65A7B0 (596 GB)
PSU
EVGA Supernova 750w G2 Gold
Cooling
5 x 80mm Generic Fans
Keyboard
Microsoft Comfort Curve 2000
Mouse
SteelSeries IKARI 62001-1 Laser or Microsoft Laser 6000
Internet Speed
1500/256
Antivirus
NOD32 v10.1.235.0
Browser
FireFox 59.0.2 X64bit
Other Info
Telstra Technicolor TG799vac Modem
LG HL-DT-ST DVDRAM GH20NS15 ATA Device
16X52X32X52 COMBO SCSI CDRom Device
Logitech Wave Keyboard
Microsoft 6000 Laser Mouse
Have you tried using General for the cell format instead of Number.
 

My Computer My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Self built using existing case
OS
Windows 7 Home Premium 64 bit sp1
CPU
Intel i5 3570 3.4Ghz Ivy Bridge SKT 1155 quad core
Motherboard
Gigabyte Z77-HD3 SKT 1155 2xSata 3, 4x USB 3.0
Memory
G-Skill Rip Jaws 16Gb (8x2) DDR3 -1600 PC3 12800 CL 10 red
Graphics Card(s)
Gigabyte NVIDIA GT610 1Gb DDR3 810/1200 PCI-E 2.0 Silent
Sound Card
NVIDIA High Definition & Realtech High Definition Audio
Monitor(s) Displays
2 x Philips 226V4L 16:9 aspect ratio
Screen Resolution
1920 x 1080 HD
Hard Drives
Samsung 840 Pro 256gb SSD, SATA 3.
Hitachi Touro Portable 1tb, USB 3.0 HDD used for image b/ups.
PSU
Corsair VS450
Case
Codeng
Cooling
PSU fan & CPU fan
Keyboard
Logitech
Mouse
Logitech Wireless trackball M570
Internet Speed
Wireless 3G. 3mg down & 550kb up.
Antivirus
Bitdefender Internet Security 2020
Browser
Opera (Current Version) & Firefox
Other Info
MS Office 2013 Pro. Davis weather station software. MGE Nova 600 avr UPS.
I have tried everything, even a Custom number of 25799, all I get is 257.99 or 258. :cry: :cry:
 

My Computer My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Homebuild
OS
Windows 7 Ultimate 64 bit SP1
CPU
DualCore Intel Pentium D 820, 2800 MHz (14 x 200)
Motherboard
Gigabyte EX58-UD3R
Memory
Kingston DDR3 (PC3-10700H) 6.0GB
Graphics Card(s)
AMD Radeon HD 6450
Sound Card
Realtek ALC882/D/M
Monitor(s) Displays
Samsung SyncMaster 2233SW
Screen Resolution
1920 x 1080
Hard Drives
Drive #1 - WDC WD2500JB-22REA0 (232 GB)
Drive #2 - WDC WD6400AAKS-65A7B0 (596 GB)
PSU
EVGA Supernova 750w G2 Gold
Cooling
5 x 80mm Generic Fans
Keyboard
Microsoft Comfort Curve 2000
Mouse
SteelSeries IKARI 62001-1 Laser or Microsoft Laser 6000
Internet Speed
1500/256
Antivirus
NOD32 v10.1.235.0
Browser
FireFox 59.0.2 X64bit
Other Info
Telstra Technicolor TG799vac Modem
LG HL-DT-ST DVDRAM GH20NS15 ATA Device
16X52X32X52 COMBO SCSI CDRom Device
Logitech Wave Keyboard
Microsoft 6000 Laser Mouse
Have you tried Office Repair as suggested by Skyred5 in post 2. To do that open Control Panel, select Programs & Features, scroll down to Microsoft Office, Right Click on it & select Change which should open a couple of Repair Options.
 

My Computer My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Self built using existing case
OS
Windows 7 Home Premium 64 bit sp1
CPU
Intel i5 3570 3.4Ghz Ivy Bridge SKT 1155 quad core
Motherboard
Gigabyte Z77-HD3 SKT 1155 2xSata 3, 4x USB 3.0
Memory
G-Skill Rip Jaws 16Gb (8x2) DDR3 -1600 PC3 12800 CL 10 red
Graphics Card(s)
Gigabyte NVIDIA GT610 1Gb DDR3 810/1200 PCI-E 2.0 Silent
Sound Card
NVIDIA High Definition & Realtech High Definition Audio
Monitor(s) Displays
2 x Philips 226V4L 16:9 aspect ratio
Screen Resolution
1920 x 1080 HD
Hard Drives
Samsung 840 Pro 256gb SSD, SATA 3.
Hitachi Touro Portable 1tb, USB 3.0 HDD used for image b/ups.
PSU
Corsair VS450
Case
Codeng
Cooling
PSU fan & CPU fan
Keyboard
Logitech
Mouse
Logitech Wireless trackball M570
Internet Speed
Wireless 3G. 3mg down & 550kb up.
Antivirus
Bitdefender Internet Security 2020
Browser
Opera (Current Version) & Firefox
Other Info
MS Office 2013 Pro. Davis weather station software. MGE Nova 600 avr UPS.
Have you tried Office Repair as suggested by Skyred5 in post 2. To do that open Control Panel, select Programs & Features, scroll down to Microsoft Office, Right Click on it & select Change which should open a couple of Repair Options.

Just ran the Repair option as you suggested - FAIL, still getting 257.99 in a cell on a NEW Workbook.
 

My Computer My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Homebuild
OS
Windows 7 Ultimate 64 bit SP1
CPU
DualCore Intel Pentium D 820, 2800 MHz (14 x 200)
Motherboard
Gigabyte EX58-UD3R
Memory
Kingston DDR3 (PC3-10700H) 6.0GB
Graphics Card(s)
AMD Radeon HD 6450
Sound Card
Realtek ALC882/D/M
Monitor(s) Displays
Samsung SyncMaster 2233SW
Screen Resolution
1920 x 1080
Hard Drives
Drive #1 - WDC WD2500JB-22REA0 (232 GB)
Drive #2 - WDC WD6400AAKS-65A7B0 (596 GB)
PSU
EVGA Supernova 750w G2 Gold
Cooling
5 x 80mm Generic Fans
Keyboard
Microsoft Comfort Curve 2000
Mouse
SteelSeries IKARI 62001-1 Laser or Microsoft Laser 6000
Internet Speed
1500/256
Antivirus
NOD32 v10.1.235.0
Browser
FireFox 59.0.2 X64bit
Other Info
Telstra Technicolor TG799vac Modem
LG HL-DT-ST DVDRAM GH20NS15 ATA Device
16X52X32X52 COMBO SCSI CDRom Device
Logitech Wave Keyboard
Microsoft 6000 Laser Mouse
Problem was all too hard so reformatted and started afresh, system was only 17 old anyway so nothing lost.
 

My Computer My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Homebuild
OS
Windows 7 Ultimate 64 bit SP1
CPU
DualCore Intel Pentium D 820, 2800 MHz (14 x 200)
Motherboard
Gigabyte EX58-UD3R
Memory
Kingston DDR3 (PC3-10700H) 6.0GB
Graphics Card(s)
AMD Radeon HD 6450
Sound Card
Realtek ALC882/D/M
Monitor(s) Displays
Samsung SyncMaster 2233SW
Screen Resolution
1920 x 1080
Hard Drives
Drive #1 - WDC WD2500JB-22REA0 (232 GB)
Drive #2 - WDC WD6400AAKS-65A7B0 (596 GB)
PSU
EVGA Supernova 750w G2 Gold
Cooling
5 x 80mm Generic Fans
Keyboard
Microsoft Comfort Curve 2000
Mouse
SteelSeries IKARI 62001-1 Laser or Microsoft Laser 6000
Internet Speed
1500/256
Antivirus
NOD32 v10.1.235.0
Browser
FireFox 59.0.2 X64bit
Other Info
Telstra Technicolor TG799vac Modem
LG HL-DT-ST DVDRAM GH20NS15 ATA Device
16X52X32X52 COMBO SCSI CDRom Device
Logitech Wave Keyboard
Microsoft 6000 Laser Mouse
Back
Top