| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
bug - type 1-4531 in any cell - returned Jan-51 workaround is '1-.
In Excel office 2k if you type 1-4351 in any cell the returned value is
Jan-51, 2-4531 =Feb-51 etc. you cannot change the format of the cell to display numbers!!! The workaround for this bug is to put an open quote mark in front of the number i.e. '1-4531, as this is the type of number I use regularly it is extremely annoying, has this already been reported and if so is there a fix for it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Capitalize first letter when type a name in each cell. | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Threaded Mode
