PHP Warning: mysql_query(): Access denied for user 'vhelpf'@'localhost' (using password: NO) in ..../includes/class_postbit.php(265) : eval()'d code on line 2

PHP Warning: mysql_query(): A link to the server could not be established in ..../includes/class_postbit.php(265) : eval()'d code on line 2

PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in ..../includes/class_postbit.php(265) : eval()'d code on line 3

PHP Warning: mysql_query(): Access denied for user 'vhelpf'@'localhost' (using password: NO) in ..../includes/class_postbit.php(265) : eval()'d code on line 2

PHP Warning: mysql_query(): A link to the server could not be established in ..../includes/class_postbit.php(265) : eval()'d code on line 2

PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in ..../includes/class_postbit.php(265) : eval()'d code on line 3

PHP Warning: mysql_query(): Access denied for user 'vhelpf'@'localhost' (using password: NO) in ..../includes/class_postbit.php(265) : eval()'d code on line 2

PHP Warning: mysql_query(): A link to the server could not be established in ..../includes/class_postbit.php(265) : eval()'d code on line 2

PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in ..../includes/class_postbit.php(265) : eval()'d code on line 3
Spreadsheet data entry problem - Vista Help Forum

Go Back   Vista Help Forum » Windows Vista » Vista Help Forum
Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2009
saarak saarak is offline
neophyte
 
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.

Saarak
Reply With Quote
  #2  
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
Default

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
  #3  
Old 04-19-2009
BigKahunaFL BigKahunaFL is offline
neophyte
 
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 11:07 PM.
Reply With Quote
Reply

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 02:29 PM
Strange Entry under Startup MSConfig Tinkerbell Vista Malware Forum 4 09-12-2008 08:01 PM
BITS won't start (qmgr.dll loaded, but entry-point DllRegisterServer not found) PartlyFish Vista Help Forum 5 08-11-2008 05:44 PM
Data (E:) and music problem ajc109 Vista Hardware Forum 0 04-06-2008 02:56 PM
data dvd problem neo_mp5 Vista Hardware Forum 2 04-06-2007 12:41 AM