Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering data using - between numbers without converting to date
I am trying to enter data into a cell using - between numbers for example
1-30-4400, excel is converting this number into a date, I can't change the way I enter this data, how can I make excel stop converting this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering data using - between numbers without converting to date
Format the cell(s) as Text prior to data entry, or precede the
data with a single apostrophe ('). The apostrophe will not show in the cell, but will in the formula bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Heather" wrote in message ... I am trying to enter data into a cell using - between numbers for example 1-30-4400, excel is converting this number into a date, I can't change the way I enter this data, how can I make excel stop converting this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering data using - between numbers without converting to date
Either put a ' before the first entry or format the cells as text.
"Heather" wrote: I am trying to enter data into a cell using - between numbers for example 1-30-4400, excel is converting this number into a date, I can't change the way I enter this data, how can I make excel stop converting this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering data using - between numbers without converting to date
Try this:
Format those cells to be text, not numbers: <Format<Cells<Number tab Category: Text Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Heather" wrote: I am trying to enter data into a cell using - between numbers for example 1-30-4400, excel is converting this number into a date, I can't change the way I enter this data, how can I make excel stop converting this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering data using - between numbers without converting to da
This is a problem with Excel.
Excel should have an option to accept exactly what you type. I have requested microsoft to remove the automatic change when it sees 1-2, 1-2-3 etc Others and I have the same problem in copying and pasting. -- Vince "Chip Pearson" wrote: Format the cell(s) as Text prior to data entry, or precede the data with a single apostrophe ('). The apostrophe will not show in the cell, but will in the formula bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Heather" wrote in message ... I am trying to enter data into a cell using - between numbers for example 1-30-4400, excel is converting this number into a date, I can't change the way I enter this data, how can I make excel stop converting this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering data using - between numbers without converting to da
This is a problem with Excel.
Excel should have an option to accept exactly what you type. I have requested microsoft to remove the automatic change when it sees 1-2, 1-2-3 etc Others and I have the same problem in copying and pasting. -- Vince "Chip Pearson" wrote: Format the cell(s) as Text prior to data entry, or precede the data with a single apostrophe ('). The apostrophe will not show in the cell, but will in the formula bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Heather" wrote in message ... I am trying to enter data into a cell using - between numbers for example 1-30-4400, excel is converting this number into a date, I can't change the way I enter this data, how can I make excel stop converting this? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering data using - between numbers without converting to date
Heather
I have the same problem with copying and pasting several columns some of which have are of the type you describe. The data can't be changed by including an ' because it is copied data. I have tried every type of preformat and I have tried Paste and Special Paste but nothing works. I have requested microsoft to change Excel so that automatic changes of this type can be switched off. I suggest you complain to microsoft or back up my request for change. -- Vince "Heather" wrote: I am trying to enter data into a cell using - between numbers for example 1-30-4400, excel is converting this number into a date, I can't change the way I enter this data, how can I make excel stop converting this? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering data using - between numbers without converting to date
"Vince" wrote in message
... "Heather" wrote: I am trying to enter data into a cell using - between numbers for example 1-30-4400, excel is converting this number into a date, I can't change the way I enter this data, how can I make excel stop converting this? I have the same problem with copying and pasting several columns some of which have are of the type you describe. The data can't be changed by including an ' because it is copied data. I have tried every type of preformat and I have tried Paste and Special Paste but nothing works. I have requested microsoft to change Excel so that automatic changes of this type can be switched off. I suggest you complain to microsoft or back up my request for change. As others have answered, format the cells as text before you enter the data. -- David Biddulph |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering data using - between numbers without converting to date
Heather
find "option to prevent Excel changing 1-2-3 to a date" and agree with the suggestion. -- Vince "Heather" wrote: I am trying to enter data into a cell using - between numbers for example 1-30-4400, excel is converting this number into a date, I can't change the way I enter this data, how can I make excel stop converting this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run a macro in a locked cell | Excel Discussion (Misc queries) | |||
Merging data looking up (Account) numbers in a coloumn | Excel Worksheet Functions | |||
bringing data from one workbook to another using a date stamp func | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |