Go Back   Vista Help Forum » Windows Vista » Vista Help Forum
Thread Tools Display Modes
Old 04-19-2009
saarak saarak is offline
Join Date: Apr 2009
Posts: 1
saarak is on a distinguished road
Default Spreadsheet data entry problem

I am new to Vista. This problem relates to both Lotus 123 and Excel spreadsheets.

When I enter numbers that look like dates, they are being interpreted as dates. For example if I enter 6-3 (meaning 6 minus 3) it is entered on the spreadsheet as 06-03 as a date (format 31-12). If I change to general number then I get a date number (39878 in this case). I want my numbers to be always inpreted as numbers.

I know that I can enter + in the cell when I start the calculation, but I didn't have to do this when I was using spreadsheets on XP.

I've tried User Setup but that didn't help.

Hope someone can help.

Reply With Quote
Old 04-19-2009
cyclic's Avatar
cyclic cyclic is offline
Agent - Level 3
Join Date: May 2008
Location: Cheshire
Posts: 751
cyclic is on a distinguished road

I don't know if you would be better served looking in software forums, rather than an operating system specific forum, as this is not specifically a Vista problem but a third party software error\incompatibility.
I know they do have forums for Microsoft Office related problems, not so sure about the aged Lotus though.
Reply With Quote
Old 04-19-2009
BigKahunaFL BigKahunaFL is offline
Join Date: Apr 2009
Posts: 3
BigKahunaFL is on a distinguished road
Thumbs up

Quick correction:
In Excel, pressing the "=" key before entering anything causes the program to recognize the following entry as a calculation.

Try formatting all of the required cells to the desired look/data type BEFORE entering the data.

Last edited by BigKahunaFL; 04-19-2009 at 10:07 PM.
Reply With Quote

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Weird Problem opening Data Execution Prevention ktadie Vista Help Forum 1 10-01-2008 01:29 PM
Strange Entry under Startup MSConfig Tinkerbell Vista Malware Forum 4 09-12-2008 07:01 PM
BITS won't start (qmgr.dll loaded, but entry-point DllRegisterServer not found) PartlyFish Vista Help Forum 5 08-11-2008 04:44 PM
Data (E:) and music problem ajc109 Vista Hardware Forum 0 04-06-2008 01:56 PM
data dvd problem neo_mp5 Vista Hardware Forum 2 04-05-2007 11:41 PM