Reply
 
LinkBack Thread Tools Display Modes
  #1   Report Post  
Old March 6th 06, 02:01 PM posted to microsoft.public.excel.misc
excelSOS
 
Posts: n/a
Default Every time i put a number with period it becomes a date and time

Hi,, please help me,, everytime i put a number with a period ,, for example
1,23 excel changes it to 1/23/2006 14:03am,,, I am going crazy because i
need to do some work and its imposible to work like this... Rgds

  #2   Report Post  
Old March 6th 06, 02:11 PM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Every time i put a number with period it becomes a date and time

Left-click on a blank, unused cell somewhere off screen and then left click
on the PaintBrush icon in the tool bar, then Left-click on the cell that's
giving you trouble.......that should clear it and return the cell format to
general.

Vaya con Dios,
Chuck, CABGx3



"excelSOS" wrote:

Hi,, please help me,, everytime i put a number with a period ,, for example
1,23 excel changes it to 1/23/2006 14:03am,,, I am going crazy because i
need to do some work and its imposible to work like this... Rgds

  #3   Report Post  
Old March 6th 06, 02:18 PM posted to microsoft.public.excel.misc
Richard O. Neville
 
Posts: n/a
Default Every time i put a number with period it becomes a date and time

Select Format-Cells and determine the formatting of the cells in which you
are entering your numbers. It will probably say Date, "x/x/xxxx". Just
change the formatting to whatever you need, such as "General."

"excelSOS" wrote in message
...
Hi,, please help me,, everytime i put a number with a period ,, for
example
1,23 excel changes it to 1/23/2006 14:03am,,, I am going crazy because i
need to do some work and its imposible to work like this... Rgds



  #4   Report Post  
Old March 6th 06, 02:22 PM posted to microsoft.public.excel.misc
Dav
 
Posts: n/a
Default Every time i put a number with period it becomes a date and time


The other option is what is your date seperator in windows, is it a
comma, change it to a / and your problems may disappear!

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=519314

  #5   Report Post  
Old March 6th 06, 03:36 PM posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default Every time i put a number with period it becomes a date and ti

how do you do that?

"Dav" wrote:


The other option is what is your date seperator in windows, is it a
comma, change it to a / and your problems may disappear!

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=519314




  #6   Report Post  
Old March 6th 06, 04:46 PM posted to microsoft.public.excel.misc
excelSOS
 
Posts: n/a
Default Every time i put a number with period it becomes a date and ti

Hello,, It doesnt workk,, I am going crazy.. I did what you wrote but it
doesnt work.. Please help me out!!

Rgds

"Richard O. Neville" wrote:

Select Format-Cells and determine the formatting of the cells in which you
are entering your numbers. It will probably say Date, "x/x/xxxx". Just
change the formatting to whatever you need, such as "General."

"excelSOS" wrote in message
...
Hi,, please help me,, everytime i put a number with a period ,, for
example
1,23 excel changes it to 1/23/2006 14:03am,,, I am going crazy because i
need to do some work and its imposible to work like this... Rgds




  #7   Report Post  
Old March 6th 06, 05:25 PM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Every time i put a number with period it becomes a date and time

You might check Tools Autocorrect, and look to see if you have an entry to
replace the period with a slash.......if so, just highlight it and
Delete......

Vaya con Dios,
Chuck, CABGx3



"excelSOS" wrote:

Hi,, please help me,, everytime i put a number with a period ,, for example
1,23 excel changes it to 1/23/2006 14:03am,,, I am going crazy because i
need to do some work and its imposible to work like this... Rgds

  #8   Report Post  
Old March 7th 06, 12:20 AM posted to microsoft.public.excel.misc
boxesss
 
Posts: n/a
Default Every time i put a number with period it becomes a date and time

I would say, go into formatting and select text. Hope this helps.

"excelSOS" wrote:

Hi,, please help me,, everytime i put a number with a period ,, for example
1,23 excel changes it to 1/23/2006 14:03am,,, I am going crazy because i
need to do some work and its imposible to work like this... Rgds



Reply
Thread Tools
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine Date & Time Cells KrunoG Excel Discussion (Misc queries) 0 January 31st 06 08:08 PM
How Do I Eliminate the Serial Number for time from Date? Bob Gotti Excel Discussion (Misc queries) 2 January 19th 06 05:24 PM
How to calculate Date & Time differences robs Excel Worksheet Functions 2 October 4th 05 04:22 PM
Using VLOOKUP with a Date and Time Charles Excel Discussion (Misc queries) 4 September 20th 05 06:38 PM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM


All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017