Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
type in 4-7 changes to 38814
Help! I am typing into cells numbers like 0-3, 4-7, 8-15, 16-30 and the 4-7
& 8-15 turn into numbers like 38814 --- I have looked at the formatting and it is the same as the 0-3, yet it automatically changes to something strange like 38814 --- what is going on? Thanks! -- flojoe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
type in 4-7 changes to 38814
Hi
Excel is interpreting the values as dates, and turning the result into the serial number of that date (7th Apr and 15th Aug) Either format the cells where you are entering the data as Text before you start, or precede your entries with a single quote so that Excel knows that they are text values and will not attempt the conversion. -- Regards Roger Govier "fkistner" wrote in message ... Help! I am typing into cells numbers like 0-3, 4-7, 8-15, 16-30 and the 4-7 & 8-15 turn into numbers like 38814 --- I have looked at the formatting and it is the same as the 0-3, yet it automatically changes to something strange like 38814 --- what is going on? Thanks! -- flojoe |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
type in 4-7 changes to 38814
Excel thinks they're dates.
Precede the codes with an apostrophe. It will not show. -- Kind regards, Niek Otten "fkistner" wrote in message ... | Help! I am typing into cells numbers like 0-3, 4-7, 8-15, 16-30 and the 4-7 | & 8-15 turn into numbers like 38814 --- I have looked at the formatting and | it is the same as the 0-3, yet it automatically changes to something strange | like 38814 --- what is going on? Thanks! | -- | flojoe |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
type in 4-7 changes to 38814
Excel thinks you are entering dates:
Use the single quote (apostrophe): '4-7 -- Gary's Student "fkistner" wrote: Help! I am typing into cells numbers like 0-3, 4-7, 8-15, 16-30 and the 4-7 & 8-15 turn into numbers like 38814 --- I have looked at the formatting and it is the same as the 0-3, yet it automatically changes to something strange like 38814 --- what is going on? Thanks! -- flojoe |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
type in 4-7 changes to 38814
Thank you --- you are a genius & saved me from pulling out all of my hair :)
Have a great day! -- flojoe "fkistner" wrote: Help! I am typing into cells numbers like 0-3, 4-7, 8-15, 16-30 and the 4-7 & 8-15 turn into numbers like 38814 --- I have looked at the formatting and it is the same as the 0-3, yet it automatically changes to something strange like 38814 --- what is going on? Thanks! -- flojoe |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
type in 4-7 changes to 38814
Thank you --- I was going crazy! Have a great day!
-- flojoe "Gary''s Student" wrote: Excel thinks you are entering dates: Use the single quote (apostrophe): '4-7 -- Gary's Student "fkistner" wrote: Help! I am typing into cells numbers like 0-3, 4-7, 8-15, 16-30 and the 4-7 & 8-15 turn into numbers like 38814 --- I have looked at the formatting and it is the same as the 0-3, yet it automatically changes to something strange like 38814 --- what is going on? Thanks! -- flojoe |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
type in 4-7 changes to 38814
Thank you I was going crazy! Have a great day
-- flojoe "Niek Otten" wrote: Excel thinks they're dates. Precede the codes with an apostrophe. It will not show. -- Kind regards, Niek Otten "fkistner" wrote in message ... | Help! I am typing into cells numbers like 0-3, 4-7, 8-15, 16-30 and the 4-7 | & 8-15 turn into numbers like 38814 --- I have looked at the formatting and | it is the same as the 0-3, yet it automatically changes to something strange | like 38814 --- what is going on? Thanks! | -- | flojoe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel-stacking type within a cell-HOW?? | Excel Worksheet Functions | |||
How to use a tax type table (if/then with lots of detail) in a fo. | Excel Discussion (Misc queries) | |||
changing the order shown in the save type menu | Setting up and Configuration of Excel | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel |