Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Works Spreadsheet converts number to time format

07 Mar 2017   #1
Kurt Puzzled

Windows 7 Professional 64 bit
 
 
Works Spreadsheet converts number to time format

Im working in a spreadsheet for windows 7, Works.
Every time I enter 1AM (a model designation) it converts it to 1:00 AM.
How to I stop this?
Thanks.


My System SpecsSystem Spec
.
07 Mar 2017   #2
starchase

Win 7 home perm. 64 bit
 
 

I haven't worked in Works for over a decade but this should "work," put a coma in the cell first then type 1AM.
My System SpecsSystem Spec
07 Mar 2017   #3
Kurt Puzzled

Windows 7 Professional 64 bit
 
 

That appears to have worked. If I type the comma first then the alpha-numeric. I can then go back and remove the comma and everything is ok.
I don't understand it, and I think it's dumb, but that is how programmers do things.
I would venture to say that my biggest headaches come from someone else taking control of my life and thinking they know better on how to improve it.
Thank you very much for the assistance.
My System SpecsSystem Spec
.

07 Mar 2017   #4
Mellon Head

Win 7 Pro x64/Win 10 Pro x64 dual boot
 
 

Kurt,

You could also try putting an apostrophe ( ' ) before 1AM. It should work (it does in Excel). That way you don't have to go back and delete the comma. The apostrophe signifies to Works (and Excel) that this is a test cell, and the apostrophe is invisible.

I would be interested if that solves your problem without having to re-edit the cell.
My System SpecsSystem Spec
07 Mar 2017   #5
Kurt Puzzled

Windows 7 Professional 64 bit
 
 

It leaves the apostrophe in place. Curious.
My System SpecsSystem Spec
08 Mar 2017   #6
starchase

Win 7 home perm. 64 bit
 
 

I mistyped in my original answer as I intended to write apostrophe and not comma because as in Excel and Libre Office, which I use, the apostrophe does disappear leaving the desired text behind. But Works is an arcane program, and I'd expect it "should" work like Excel so I'm surprised to hear you say it doesn't! And I'm also shocked my error in typing actually led to your success albeit with an additional edit of the cell on your part!
My System SpecsSystem Spec
Reply

 Works Spreadsheet converts number to time format




Thread Tools




Similar help and support threads
Thread Forum
MS Works Spreadsheet is empty
When I open 2 Works Spreadsheets I get an error message. Other Works SS open OK. If I click the X to close the error box an empty SS appears, yet there is data there. (16k). The title says "Unsaved Spreadsheet". http://dickh.zenfolio.com/img/s1/v22/p1806981243-4.jpg
Microsoft Office
works spreadsheet
Starting a few months ago any spreadsheet I created in Microsoft Works would develop the "hiccups". The spread sheet would create and you could post entries but only between the fluctuations of the "hourglass" icon cycling about every 2 seconds. I would resolve this by restoring to an earlier...
Microsoft Office
Works Spreadsheet Grid Lines
When I copy and paste some info from a Works Spreadsheet into an .RTF, a .TXT or .WPS file the grid lines are there. This was not always the case. I seldom do this so I have not raised the issue previously. If I paste the data into an e-mail the grid lines are not there. Also, I removed the grid...
Software
Word 07 TOC error: number cannot be represented in specified format
Hi I've done dozens of ToC's in Word without problem, but one file is giving me trouble. Using the field {TOC \o "1-4" \h \z \u}, in Page View instead of page numbers I get: Error! Number cannot be represented in specified format. I have another field-based ToC in the document with the...
Microsoft Office
Must enter serial number each time you open Lightroom
Installed 64-bit Lightroom 2.5 on new Win-7 box. Entered serial numbers and LR started OK, but when I close LR and restart, it asks for serial numbers again Lightroom Forum provided the link You must enter your serial number each time you open Photoshop Lightroom 1.x, which gives registry-fix...
Software


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 03:44.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App